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

From Tom Lane
Subject Re: Interpretting WAL debug.
Date
Msg-id 19818.1030642791@sss.pgh.pa.us
Whole thread Raw
In response to Re: Interpretting WAL debug.  (Murthy Kambhampaty <Murthy.Kambhampaty@goeci.com>)
List pgsql-admin
Murthy Kambhampaty <Murthy.Kambhampaty@goeci.com> writes:
> At bottom, I suspect you can get your machine tuned without WAL debug, and
> Bruce's paper on tuning, which it looks like you've been reading. I don't
> think, you need to turn on WAL debug for the particular question you asked.

I agree.  The WAL debug code is really intended for *debugging* WAL, not
for tuning purposes.  I think all you really need care about is whether
you get "new log file created" messages and what the frequency of
checkpoints is.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: delete with referential integrity
Next
From: Bruce Momjian
Date:
Subject: Re: timeout