Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group