Re: WAL archiving idle database - Mailing list pgsql-general

From Tom Lane
Subject Re: WAL archiving idle database
Date
Msg-id 16326.1193493860@sss.pgh.pa.us
Whole thread Raw
In response to Re: WAL archiving idle database  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-general
Simon Riggs <simon@2ndquadrant.com> writes:
> We *could* force it to perform a log switch whether or not new WAL has
> been written.

That would be a truly awful idea.

I think the right answer for Kevin's situation really is to be doing a
dummy transaction every few minutes as one component of his system
monitoring.  That way he gets the behavior he wants, and it needn't
preclude us from fixing the default behavior to be less wasteful.

            regards, tom lane

pgsql-general by date:

Previous
From: andy
Date:
Subject: Re: Postgres+Apache+PHP (again, but in different setup)
Next
From: Tom Lane
Date:
Subject: Re: I want to search my project source code