Re: Interpretting WAL debug. - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Interpretting WAL debug.
Date
Msg-id 200208292143.g7TLhpV23785@candle.pha.pa.us
Whole thread Raw
In response to Re: Interpretting WAL debug.  (Andrew Sullivan <andrew@libertyrms.info>)
List 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 by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Interpretting WAL debug.
Next
From: Andrew Sullivan
Date:
Subject: Re: Running postgres on a read-only file system