Re: reducing statistics write overhead

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: reducing statistics write overhead
Дата
Msg-id 13344.1231339449@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: reducing statistics write overhead  (Martin Pihlak <martin.pihlak@gmail.com>)
Ответы Re: reducing statistics write overhead  (Martin Pihlak <martin.pihlak@gmail.com>)
Список pgsql-hackers
Martin Pihlak <martin.pihlak@gmail.com> writes:
> As I understand the autovacuum workers need up to date stats to minimize the
> risk of re-vacuuming a table (in case it was already vacuumed by someone else).

I never understood why autovacuum should need a particularly short fuse
on the stats file age to start with.  If the launcher is launching
multiple workers into the same database with only a few milliseconds
between them, isn't the launcher pretty broken anyhow?  ISTM that stats
files even several seconds old ought to be plenty good enough.
        regards, tom lane


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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: New patch for Column-level privileges
Следующее
От: "Gregory Maxwell"
Дата:
Сообщение: Re: Significantly larger toast tables on 8.4?