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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Romuald Brunet" <romuald(dot)brunet(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slower query after psql changed it's execution plan
Date: 2009-03-23 14:20:39
Message-ID: 49C75467.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Romuald Brunet <romuald(dot)brunet(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-03-23 14:26:38 Re: Slower query after psql changed it's execution plan
Previous Message Romuald Brunet 2009-03-23 13:52:44 Slower query after psql changed it's execution plan