Re: Monitoring Transaction Log size

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Ziegelwanger, Silvio" <Silvio(dot)Ziegelwanger(at)fabasoft(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Monitoring Transaction Log size
Date: 2007-01-18 10:19:17
Message-ID: bf54be870701180219l21c60f92k8223184a24877be1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)2ndquadrant(dot)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
>
>
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Arjen van der Meijden 2007-01-18 10:24:10 Re: Configuration Advice
Previous Message Simon Riggs 2007-01-18 09:55:59 Re: Monitoring Transaction Log size