To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
cc: "Robert Haas" <robertmhaas@gmail.com>,
	"Richard Yen" <richyen@iparadigms.com>,
	"Scott Marlowe" <scott.marlowe@gmail.com>, pgsql-performance@postgresql.org
Subject: Re: [Slony1-general] WAL partition overloaded--by autovacuum? 
In-reply-to: <4C35DADF020000250003326D@gw.wicourts.gov> 
References: <03D2C5F0-F222-4088-B5E4-8DA688565B70@iparadigms.com>
	<AANLkTik1oR2fMBp9pzpeYUgrANXKpK0B23scXONQEK1z@mail.gmail.com>
	<78E79F0B-5C6C-4BDA-B69C-C0FBF69ABBC7@iparadigms.com>
	<AANLkTim9s_S0LS3VtjxUVGuGOHkl_2n7YfpB3KWwdlm-@mail.gmail.com>
	<4C35DADF020000250003326D@gw.wicourts.gov>
Comments: In-reply-to "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
	message dated "Thu, 08 Jul 2010 14:04:15 -0500"
Date: Thu, 08 Jul 2010 15:27:02 -0400
Message-ID: <323.1278617222@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> You're not alone.  At first I was assuming that it was because of
> archiving, but the OP says that's turned off.  Unless it had been on
> and there wasn't a *restart* after changing the configuration,

Yeah, I was less than convinced by his eyeball report of that, too.
"show archive_mode" would be a much more convincing check of the
server's state.  Or would have been, if the server hadn't been restarted
since the problem occurred.

archive_mode on with a bad archive_command would lead directly to the
reported problem ... although it should also lead to pretty obvious
complaints in the postmaster log.

(Hmm ... but those complaints are logged at level WARNING, which as
discussed elsewhere is really lower than LOG.  Should we change them?)

			regards, tom lane