Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Index usage
- From: Scott Matseas <smatseas(at)intrusic(dot)com>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Index usage
- Date: Mon, 21 Aug 2006 16:25:10 -0400
Tom Lane wrote:
What other planner parameters have you been fooling with?
Hi Tom, The other parameters that have been changed are: set join_collapse_limit to 1 set enable_sort to off We are using version 8.1.3. We've noticed the query plan changing dependingon the amount of data in the tables especially when the query looks at more rows
in tableA. The parameter work_mem is set to 262,144. Thanks, Scott
- References:
- Index usage
- From: Scott Matseas
- Re: Index usage
- From: Tom Lane
- Index usage
- Prev by Date: Re: Vacuum not identifying rows for removal..
- Next by Date: Re: Vacuum not identifying rows for removal..
- Previous by thread: Re: Index usage
- Next by thread: Vacuum not identifying rows for removal..
- Indexes: