Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BB3F62E3AE8 for ; Fri, 14 Dec 2007 12:07:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 63535-01 for ; Fri, 14 Dec 2007 12:07:52 -0400 (AST) Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 7C7E12E3AD6 for ; Fri, 14 Dec 2007 12:07:52 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 14 Dec 2007 10:07:51 -0600 Message-Id: <476255EC.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Fri, 14 Dec 2007 10:07:41 -0600 From: "Kevin Grittner" To: "Simon Riggs" Cc: Subject: Re: Heavy write activity on first vacuum of fresh TOAST data References: <4760FF69.EE98.0025.0@wicourts.gov> <1197562283.4255.1829.camel@ebony.site> <47611B9D.EE98.0025.0@wicourts.gov> <1197569564.4255.1855.camel@ebony.site> <47614D86.EE98.0025.0@wicourts.gov> <1197582010.4255.1912.camel@ebony.site> In-Reply-To: <1197582010.4255.1912.camel@ebony.site> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/215 X-Sequence-Number: 28031 >>> On Thu, Dec 13, 2007 at 3:40 PM, in message <1197582010.4255.1912.camel@ebony.site>, Simon Riggs wrote:=20 > On Thu, 2007-12-13 at 15:19 -0600, Kevin Grittner wrote: =20 >> So one would expect a write-intensive initial vacuum after a >> PITR-style recovery? =20 > An interesting issue when running with full_page_writes off. =20 I'm curious. How does the full_page_writes setting affect this? =20 -Kevin =20