Re: Slower query after psql changed it's execution plan

Romuald Brunet <romuald.brunet@gmail.com> wrote:
> The statistics are at the default value everywhere (10)

Try setting that to 100 and running ANALYZE.

The small size of the sample with the default of 10 happened to land
you with a bad estimate this time.  (If the numbers it has were
actually representative of the data, the plan it's using would be
reasonable.)

-Kevin