Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 9AE752E2F20
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 13 Dec 2007 17:19:50 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 10845-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 13 Dec 2007 17:19:43 -0400 (AST)
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id 14A1B2E2F06
	for <pgsql-performance@postgresql.org>;
	Thu, 13 Dec 2007 17:19:46 -0400 (AST)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Thu, 13 Dec 2007 15:19:45 -0600
Message-Id: <47614D86.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Thu, 13 Dec 2007 15:19:34 -0600
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Simon Riggs" <simon@2ndquadrant.com>
Cc: <pgsql-performance@postgresql.org>
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>
In-Reply-To: <1197569564.4255.1855.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/203
X-Sequence-Number: 28019

>>> On Thu, Dec 13, 2007 at 12:12 PM, in message
<1197569564.4255.1855.camel@ebony.site>, Simon Riggs <simon@2ndquadrant.com=
>
wrote:=20
> On Thu, 2007-12-13 at 11:46 -0600, Kevin Grittner wrote:
>> If the hint bit changes are written to the WAL ...
>=20
> They're not.
=20
So one would expect a write-intensive initial vacuum after a
PITR-style recovery?
=20
What impact would lack of the hint bits have until a vacuum?
=20
-Kevin
=20