On Wed, Mar 23, 2011 at 1:12 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> AFAICT, what's happening in this query is that PostgreSQL's statistics
> on the device_nodes and several other tables are slightly out of date
> (as in 5% of the table).
What about some manner of query feedback mechanism ( along the lines
of what explain analyze yields ) to track "stats staleness" in
Probably, I misunderstand the costs of executing explain analyze.
In response to
pgsql-performance by date
|Next:||From: Cédric Villemain||Date: 2011-03-23 20:23:46|
|Subject: Re: buffercache/bgwriter|
|Previous:||From: Claudio Freire||Date: 2011-03-23 17:35:55|
|Subject: Re: Shouldn't we have a way to avoid "risky" plans?|