Re: Searching for the cause of a bad plan - Mailing list pgsql-performance

From Ron Mayer
Subject Re: Searching for the cause of a bad plan
Date
Msg-id 46FBF174.1020206@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Searching for the cause of a bad plan  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Searching for the cause of a bad plan
List pgsql-performance
Csaba Nagy wrote:
>
> Well, my problem was actually solved by rising the statistics target,

Would it do more benefit than harm if postgres increased the
default_statistics_target?

I see a fair number of people (myself included) asking questions who's
resolution was to ALTER TABLE SET STATISTICS; and I think relatively
fewer (if any?) people concerned about space in pg_statistic
or people improving analyze time by reducing the statistics target.

pgsql-performance by date:

Previous
From: Kevin Kempter
Date:
Subject: Tuning for warm standby
Next
From: "Peter Koczan"
Date:
Subject: sequence query performance issues