Skip site navigation (1) Skip section navigation (2)

Re: I/O on select count(*)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: "Decibel!" <decibel(at)decibel(dot)org>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: I/O on select count(*)
Date: 2008-05-26 15:36:57
Message-ID: 21814.1211816217@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> writes:
> 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.

Which in fact is what Simon suggested, not the other thing.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Campbell, LanceDate: 2008-05-26 17:10:07
Subject: Re: Symbolic Links to Tablespaces
Previous:From: Tom LaneDate: 2008-05-26 15:08:51
Subject: Re: Symbolic Links to Tablespaces

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group