Postgres Pro
Downloads
Home   >   mailing lists

Re: Monitoring Transaction Log size - Mailing list pgsql-performance

From Shoaib Mir
Subject Re: Monitoring Transaction Log size
Date
Msg-id bf54be870701180219l21c60f92k8223184a24877be1@mail.gmail.com
Whole thread Raw
In response to Re: Monitoring Transaction Log size  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-performance
Tree view
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 <simon@2ndquadrant.com> wrote:
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 some reason.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



pgsql-performance by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Monitoring Transaction Log size
Next
From: Arjen van der Meijden
Date:
Subject: Re: Configuration Advice