Re: Shouldn't we have a way to avoid "risky" plans?

Поиск
Список
Период
Сортировка
От Justin Pitts
Тема Re: Shouldn't we have a way to avoid "risky" plans?
Дата
Msg-id AANLkTikeS8ChvSydcMXhLbz8t4AUUx+iUFTinANwHtfX@mail.gmail.com
обсуждение исходный текст
Ответ на Shouldn't we have a way to avoid "risky" plans?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On Wed, Mar 23, 2011 at 1:12 PM, Josh Berkus <josh@agliodbs.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
general?

Probably, I misunderstand the costs of executing explain analyze.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: Shouldn't we have a way to avoid "risky" plans?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Shouldn't we have a way to avoid "risky" plans?