Re: Potential autovacuum optimization: new tables

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Potential autovacuum optimization: new tables
Дата
Msg-id 20121013012533.GD29165@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Potential autovacuum optimization: new tables  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
* Josh Berkus (josh@agliodbs.com) wrote:
> Because Snowman asked me for an example:

Thanks. :)

> That's a 25X difference in execution time.  This is not the first time
> I've seen this issue.

If we can figure out an 'easy' solution to this, I'd definitely vote for
it being back-patched.  Having a table simply never get analyze'd
strikes me as a very bad thing.
Thanks again,
    Stephen

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Potential autovacuum optimization: new tables
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Potential autovacuum optimization: new tables