Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Why the difference in plans ??
- From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Why the difference in plans ??
- Date: Fri, 15 Sep 2006 18:05:09 +0200
On Fri, 2006-09-15 at 10:08 -0400, Tom Lane wrote: > but it seems there are only 7. Try increasing your statistics target > and re-analyzing. Do you mean with "increasing my statistics target" changing the value of "default_statistics_target = 10" to a bigger number? If so, changing it to 900 did not make any difference (PostgreSQL restarted, vacuumed analysed etc). -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl
- Follow-Ups:
- Re: Why the difference in plans ??
- From: Tom Lane
- Re: Why the difference in plans ??
- References:
- Why the difference in plans ??
- From: Joost Kraaijeveld
- Re: Why the difference in plans ??
- From: Tom Lane
- Why the difference in plans ??
- Prev by Date: Re: Optimize SQL
- Next by Date: Re: Why the difference in plans ??
- Previous by thread: Re: Why the difference in plans ??
- Next by thread: Re: Why the difference in plans ??
- Indexes: