Postgres Professional
   

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

From: Kevin Grittner
Subject: Re: Slower query after psql changed it's execution plan
Date: ,
Msg-id: 49C75467.EE98.0025.0@wicourts.gov
(view: Whole thread, Raw)
In response to: Slower query after psql changed it's execution plan  (Romuald Brunet)
List: pgsql-performance 
Romuald Brunet <> 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

pgsql-performance by date:

Previous:
From: Tom Lane
Date:
Subject: Re: multiple threads inserting into the same table
Next:
From: Brian Cox
Date:
Subject: Re: multiple threads inserting into the same table