From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
---|---|
To: | <josh(at)agliodbs(dot)com>, "'Rob Fielding'" <rob(at)dsvr(dot)net>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: WAL Optimisation - configuration and usage |
Date: | 2004-03-02 22:16:12 |
Message-ID: | 004901c400a3$fb570570$5baa87d9@LaptopDellXP |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-hackers-pitr pgsql-performance |
>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 dont 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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2004-03-02 22:53:09 | Re: Out of space situation and WAL log pre-allocation (was Tablespaces) |
Previous Message | Joe Conway | 2004-03-02 21:56:16 | Re: IN and ANY |
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2004-03-03 00:01:11 | Re: WAL Optimisation - configuration and usage |
Previous Message | Raymond Siebert | 2004-03-02 14:20:08 | Re: Archival API |
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2004-03-02 22:36:52 | Re: Scaling further up |
Previous Message | Anjan Dave | 2004-03-02 22:03:32 | Re: Scaling further up |