"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> 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
