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: 2006-09-15 16:17:44
Message-ID: 2479.1158337064@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Arjen van der Meijden 2006-09-15 16:22:55 Re: Optimize SQL
Previous Message Joost Kraaijeveld 2006-09-15 16:05:09 Re: Why the difference in plans ??