Re: [PERFORM] Monitoring Transaction Log size

2007-01-18 Thread Shoaib Mir
Suggested in case he wants to do a log switch after certain amount of time... --- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/18/07, Simon Riggs <[EMAIL PROTECTED]> wrote: On Wed, 2007-01-17 at 23:03 +0500, Shoaib Mir wrote: > archive_timeout (came in ver 8.2) might help you wi

Re: [PERFORM] Monitoring Transaction Log size

2007-01-18 Thread Simon Riggs
On Wed, 2007-01-17 at 23:03 +0500, Shoaib Mir wrote: > archive_timeout (came in ver 8.2) might help you with customizing the > size for log files. I'm not sure that it will. If anything it could produce more log files, which could lead to a backlog if the archive_command isn't functioning for som

Re: [PERFORM] Monitoring Transaction Log size

2007-01-17 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> 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

Re: [PERFORM] Monitoring Transaction Log size

2007-01-17 Thread Stefan Kaltenbrunner
Joshua D. Drake wrote: > Ziegelwanger, Silvio wrote: >> Hi, >> >> >> >> 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. wel in recent versions of pg it should be pret

Re: [PERFORM] Monitoring Transaction Log size

2007-01-17 Thread Shoaib Mir
archive_timeout (came in ver 8.2) might help you with customizing the size for log files. - Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/17/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Ziegelwanger, Silvio wrote: > Hi, > > > > how can I monitor the size of the transa

Re: [PERFORM] Monitoring Transaction Log size

2007-01-17 Thread Joshua D. Drake
Ziegelwanger, Silvio wrote: > Hi, > > > > 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. Sincerely, Joshua D. Drake > > > > Best Regards > > > > Silvio > >

[PERFORM] Monitoring Transaction Log size

2007-01-17 Thread Ziegelwanger, Silvio
Hi, how can I monitor the size of the transaction log files using SQL Statements? Best Regards Silvio Silvio Ziegelwanger Research & Development Fabalabs Software GmbH Honauerstraße 4 4020 Linz Austria Tel: [43] (732) 60 61 62 Fax: [43] (732) 60 61 62-609 E-Mail: [EMAIL PROTECTED]