Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3EF56632522 for ; Thu, 8 Jul 2010 16:25:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 64294-02 for ; Thu, 8 Jul 2010 19:25:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og120.obsmtp.com (exprod7og120.obsmtp.com [64.18.2.18]) by mail.postgresql.org (Postfix) with SMTP id 4B47D6321BB for ; Thu, 8 Jul 2010 16:25:08 -0300 (ADT) Received: from source ([209.85.212.169]) by exprod7ob120.postini.com ([64.18.6.12]) with SMTP ID DSNKTDYmE35t1x6B+xtDCpofk6RX+dR6dIDo@postini.com; Thu, 08 Jul 2010 12:25:09 PDT Received: by pxi7 with SMTP id 7so444171pxi.28 for ; Thu, 08 Jul 2010 12:25:06 -0700 (PDT) Received: by 10.114.93.9 with SMTP id q9mr10022048wab.120.1278617106642; Thu, 08 Jul 2010 12:25:06 -0700 (PDT) Received: from [192.168.1.86] (99-101-9-250.lightspeed.sndgca.sbcglobal.net [99.101.9.250]) by mx.google.com with ESMTPS id k23sm256693waf.5.2010.07.08.12.25.05 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 08 Jul 2010 12:25:05 -0700 (PDT) Subject: Re: [Slony1-general] WAL partition overloaded--by autovacuum? Mime-Version: 1.0 (Apple Message framework v1081) Content-Type: text/plain; charset=us-ascii From: Richard Yen In-Reply-To: <4C35DADF020000250003326D@gw.wicourts.gov> Date: Thu, 8 Jul 2010 12:25:01 -0700 Cc: "Robert Haas" , "Scott Marlowe" , Content-Transfer-Encoding: quoted-printable Message-Id: <855D47FE-2386-4933-BED3-55FE2BA42CC0@iparadigms.com> References: <03D2C5F0-F222-4088-B5E4-8DA688565B70@iparadigms.com> <78E79F0B-5C6C-4BDA-B69C-C0FBF69ABBC7@iparadigms.com> <4C35DADF020000250003326D@gw.wicourts.gov> To: "Kevin Grittner" X-Mailer: Apple Mail (2.1081) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.2 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201007/118 X-Sequence-Number: 39507 On Jul 8, 2010, at 12:04 PM, Kevin Grittner wrote: > Robert Haas wrote: >=20 >> I don't understand how you managed to fill up 37GB of disk with >> WAL files. Every time you fill up checkpoint_segments * 16MB of >> WAL files, you ought to get a checkpoint. When it's complete, WAL >> segments completely written before the start of the checkpoint >> should be recyclable. Unless I'm confused, which apparently I am. >=20 > 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, I > can't see how this could happen, and was hoping someone else could > cast some light on the issue. I'm fairly confused myself. I'm beginning to think that because = data/base and data/pg_xlog were on the same partition (/db), when the = /db partition filled, up the WAL files couldn't get flushed to = data/base, thereby preventing data/pg_xlog from being emptied out, as = per the documentation. My concern is that--as in the original post--there were moments where = 129 WAL files were generated in one minute. Is it plausible that this = autovacuum could be responsible for this? --Richard=