Re: Interpretting WAL debug.

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Interpretting WAL debug.
Дата
Msg-id 200208292143.g7TLhpV23785@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Interpretting WAL debug.  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-admin
Andrew Sullivan wrote:
> On Thu, Aug 29, 2002 at 04:03:09PM -0400, Bruce Momjian wrote:
> >
> > Add timestamps to the logs.  See my article on Hardware performance
> > tuning on the techdocs.postgresql.org site.
>
> But please note that adding the timestamp itself imposes a
> performance penalty, because you have to call to get the time of day
> for every log write.

There is a TODO item to add a GUC option and complain if checkpoints
happen more frequenly than X seconds.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Interpretting WAL debug.
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Running postgres on a read-only file system