Re: Why the difference in plans ?? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Why the difference in plans ??
Date
Msg-id 2479.1158337064@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why the difference in plans ??  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-performance
Joost Kraaijeveld <J.Kraaijeveld@Askesis.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

pgsql-performance by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Re: Why the difference in plans ??
Next
From: Arjen van der Meijden
Date:
Subject: Re: Optimize SQL