"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> Ziegelwanger, Silvio wrote:
>> how can I monitor the size of the transaction log files using SQL Statements?
> You can't. You would have to write a custom function to heck the size of
> the xlog directory.
Perhaps more to the point, why do you think you need to? pg_xlog should
stay pretty level at approximately 2*checkpoint_segments xlog files
(once it's ramped up to that size, which might take a heavy burst of
activity if checkpoint_segments is large).
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Chris Browne||Date: 2007-01-17 23:08:44|
|Subject: Re: Configuration Advice|
|Previous:||From: Kevin Hunter||Date: 2007-01-17 22:15:24|
|Subject: DB benchmark and pg config file help|