Re: Large pgstat.stat file causes I/O storm

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Large pgstat.stat file causes I/O storm
Дата
Msg-id 24305.1201634445@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Large pgstat.stat file causes I/O storm  (Cristian Gafton <gafton@rpath.com>)
Ответы Re: Large pgstat.stat file causes I/O storm  (Cristian Gafton <gafton@rpath.com>)
Список pgsql-hackers
Cristian Gafton <gafton@rpath.com> writes:
> Autovacuum is disabled, since the database is mostly read only. There is a 
> "vacuumdb -a -z" running nightly on the box. However, the application that 
> queries it does a lot of work with temporary tables - would those bloat 
> the stats at all?

Conceivably, if you mean a lot of short-lived tables rather than a lot
of operations on a few tables.  However, I'd think that would result in
a steady accumulation of stats entries, not a sudden jump as you seemed
to describe.
        regards, tom lane


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

Предыдущее
От: Cristian Gafton
Дата:
Сообщение: Re: Large pgstat.stat file causes I/O storm
Следующее
От: Cristian Gafton
Дата:
Сообщение: Re: Large pgstat.stat file causes I/O storm