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:

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