Re: [HACKERS] WAL Optimisation - configuration and usage

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "'Neil Conway'" <neilc(at)samurai(dot)com>
Cc: <josh(at)agliodbs(dot)com>, <pgsql-performance(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] WAL Optimisation - configuration and usage
Date: 2004-03-09 20:26:55
Message-ID: 006601c40614$df319e20$f3bd87d9@LaptopDellXP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-pitr pgsql-performance

>Neil Conway
> Simon Riggs wrote:
> > On the other hand, I was just about to change the wal_debug
behaviour to
> > allow better debugging of PITR features as they're added.
>
> That's a development activity. Enabling the WAL_DEBUG #ifdef by
> default during the 7.5 development cycle would be uncontroversial, I
> think.

Yes that's the best proposal. Can I leave that with you?

> > I think it is very important to be able to put the system fairly
> > easily into debug mode
>
> It is? Why would this be useful for non-development activities?
>
> (It may well be the case that we ought to report more or better
> information about the status of the WAL subsystem; but WAL_DEBUG is
> surely not the right mechanism for emitting information intended for
> an administrator.)

Right again. I guess my proposal amounted to quick-and-dirty logging.

I'll think some more.

Best Regards, Simon Riggs

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-03-09 21:07:54 Re: cvs breakage
Previous Message Andrew Dunstan 2004-03-09 20:21:31 cvs breakage

Browse pgsql-hackers-pitr by date

  From Date Subject
Next Message Simon Riggs 2004-03-09 23:10:01 PITR: Request for assistance with alpha test plan
Previous Message Simon Riggs 2004-03-08 23:28:25 Re: [PERFORM] WAL Optimisation - configuration and usage

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Spiegelberg 2004-03-09 20:29:43 syslog slowing the database?
Previous Message Shea,Dan [CIS] 2004-03-09 20:17:59 Cluster and vacuum performance