pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndquadrant.com>
To: josh@agliodbs.com
To: 'Rob Fielding' <rob@dsvr.net>
To: pgsql-performance@postgresql.org
Subject: Re: WAL Optimisation - configuration and usage
Date: Tue, 2 Mar 2004 22:16:12 -0000
Message-ID: <004901c400a3$fb570570$5baa87d9@LaptopDellXP> (raw)
In-Reply-To: <200403011710.07289.josh@agliodbs.com>

>Josh Berkus wrote
> >Simon Riggs wrote
> > Please set WAL_DEBUG to 1 so we can see a bit more info: thanks.
> 
> I'm pretty sure that WAL_DEBUG requires a compile-time option.

In my naiveté, I just set and use it. I discovered it in the code, then
set it to take advantage.

I'm surprised, but you are right, the manual does SAY this requires a
compile time option; it is unfortunately not correct. Maybe this was
once as you say? If Rob is using 7.2.2 maybe this still applies to him?
I don’t know.

Setting wal_debug > 0 in postgresql.conf sets a variable XLOGDEBUG,
which although it is all capitals is not in fact a compiler directive,
as it looks. This variable is used within xlog.c to output **too much**
information to the log. However, it is the only option at present.

This prompts me however to consider the idea of having various levels of
WAL debug output, or using some kind of log_checkpoint mechanism to
better understand what is going on.

Best Regards, Simon Riggs




view thread (18+ messages)  latest in thread

Message-ID: <004901c400a3$fb570570$5baa87d9@LaptopDellXP>
Permalink:  ../004901c400a3$fb570570$5baa87d9@LaptopDellXP/
Also on:    postgresql.org/message-id/004901c400a3$fb570570$5baa87d9@LaptopDellXP

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: simon@2ndquadrant.com, josh@agliodbs.com, rob@dsvr.net
  Subject: Re: WAL Optimisation - configuration and usage
  In-Reply-To: <004901c400a3$fb570570$5baa87d9@LaptopDellXP>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox