Re: Megabytes of stats saved after every connection

Поиск
Список
Период
Сортировка
От Guy Rouillier
Тема Re: Megabytes of stats saved after every connection
Дата
Msg-id CC1CF380F4D70844B01D45982E671B239E89E3@mtxexch01.add0.masergy.com
обсуждение исходный текст
Ответ на Megabytes of stats saved after every connection  (Phil Endecott <spam_from_postgresql_general@chezphil.org>)
Ответы Re: Megabytes of stats saved after every connection  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-general
Jan Wieck wrote:

> Then again, the stats file is only written. There is nothing that
> actually forces the blocks out. On a busy system, one individual stats
> file will be created, written to, renamed, live for 500ms and be
> thrown away by the next stat files rename operation. I would assume
> that with a decent filesystem and appropriate OS buffers, none of the
> data blocks of most stat files even hit the disk. I must be missing
> something.

(From someone who is at best semi-informed).. Unless battery-backed
cache is available, we are advised to run with fsync enabled.  Wouldn't
that affect the stats files as well?

--
Guy Rouillier


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Megabytes of stats saved after every connection
Следующее
От: "Peter L. Berghold"
Дата:
Сообщение: ecpg and C++