Skip site navigation (1) Skip section navigation (2)

Re: Slower query after psql changed it's executionplan

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 executionplan
Date: 2009-03-23 14:20:39
Message-ID: 49C75467.EE98.0025.0@wicourts.gov (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group