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

Re: [HACKERS] WAL archiving idle database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Brian Wipf <brian(at)clickspace(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] WAL archiving idle database
Date: 2007-10-26 23:24:39
Message-ID: 1335.1193441079@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> Keep in mind that even in the current system, your configuration is
> variable based on the checkpoint_timeout setting.

Yeah, and he has to keep this less than archive_timeout in order for
it to work the way he wants, which is probably not good for performance.
(Sane settings of checkpoint_timeout are probably higher, not lower,
than what people are likely to use for archive_timeout.)

I think my recommendation to Kevin would be to force some trivial
transaction to occur a little before each expected archive_timeout,
so that there will be something to be archived.  This would have the
additional advantage that the monitor is checking that the database is
actually responding to queries, whereas just noting that it's spitting
out WAL files doesn't really prove that --- especially not if mere
no-op checkpoints can cause WAL files to be emitted.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Jeff DavisDate: 2007-10-26 23:28:06
Subject: Re: [HACKERS] WAL archiving idle database
Previous:From: Jeff DavisDate: 2007-10-26 23:15:59
Subject: Re: [HACKERS] WAL archiving idle database

pgsql-general by date

Next:From: Jeff DavisDate: 2007-10-26 23:28:06
Subject: Re: [HACKERS] WAL archiving idle database
Previous:From: Jeff DavisDate: 2007-10-26 23:15:59
Subject: Re: [HACKERS] WAL archiving idle database

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