Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Why the difference in plans ??
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Why the difference in plans ??
- Date: Fri, 15 Sep 2006 12:17:44 -0400
Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> writes: > 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). Hm, did the "353" rowcount estimate not change at all? regards, tom lane
- References:
- Why the difference in plans ??
- From: Joost Kraaijeveld
- Re: Why the difference in plans ??
- From: Tom Lane
- Re: Why the difference in plans ??
- From: Joost Kraaijeveld
- Why the difference in plans ??
- Prev by Date: Re: Why the difference in plans ??
- Next by Date: Re: Optimize SQL
- Previous by thread: Re: Why the difference in plans ??
- Next by thread: Lanzamiento www.PortalTPV.com
- Indexes: