Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 56F712E0052
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Mon, 26 May 2008 10:03:40 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 16582-01
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Mon, 26 May 2008 10:03:28 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail01.enterprisedb.com (mail01.enterprisedb.com
 [63.246.7.168])
	by developer.postgresql.org (Postfix) with ESMTP id A36DC2E004D
	for <pgsql-performance@postgresql.org>;
	Mon, 26 May 2008 10:03:33 -0300 (ADT)
thread-index: Aci/MQBfA9KJgfh5Qi6XV8N9lSuY0Q==
Received: from [87.127.95.195] ([87.127.95.195]) by mail01.enterprisedb.com
	over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959);
	Mon, 26 May 2008 09:04:15 -0400
Message-ID: <483AB515.5050201@enterprisedb.com>
Date: Mon, 26 May 2008 14:03:17 +0100
Content-Class: urn:content-classes:message
Importance: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4133
From: "Heikki Linnakangas" <heikki@enterprisedb.com>
Organization: EnterpriseDB
User-Agent: Mozilla-Thunderbird 2.0.0.12 (X11/20080420)
MIME-Version: 1.0
To: "Decibel!" <decibel@decibel.org>
Cc: "Greg Smith" <gsmith@gregsmith.com>,
	<pgsql-performance@postgresql.org>
Subject: Re: I/O on select count(*)
References: <920841.71690.qm@web44808.mail.sp1.yahoo.com>
	<482B1D5F.EE98.0025.0@wicourts.gov>
	<Pine.GSO.4.64.0805142133250.27290@westnet.com>
	<20080515020553.GN9838@alvh.no-ip.org>
	<Pine.LNX.4.64.0805151245360.16756@aragorn.flymine.org>
	<20080515155232.GC8221@alvh.no-ip.org>
	<Pine.GSO.4.64.0805161118210.4987@westnet.com>
	<20080516201528.GJ13061@alvh.no-ip.org>
	<18382.1210992302@sss.pgh.pa.us>
	<Pine.GSO.4.64.0805180113450.8667@westnet.com>
	<F16DFE65-7DC5-4D5A-9B18-4F6FA070ACD8@decibel.org>
In-Reply-To: <F16DFE65-7DC5-4D5A-9B18-4F6FA070ACD8@decibel.org>
Content-Type: text/plain;
	format=flowed;
	charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 26 May 2008 13:04:15.0750 (UTC)
	FILETIME=[002FE260:01C8BF31]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200805/331
X-Sequence-Number: 30299

Decibel! wrote:
> Also, Simon and Tom had an idea at PGCon: Don't set hint-bits in the 
> back-end if the page isn't already dirty. 

Or even better: set the hint-bits, but don't dirty the page.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com