Re: I/O on select count(*) - Mailing list pgsql-performance

From Tom Lane
Subject Re: I/O on select count(*)
Date
Msg-id 21814.1211816217@sss.pgh.pa.us
Whole thread Raw
In response to Re: I/O on select count(*)  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: I/O on select count(*)
List pgsql-performance
"Heikki Linnakangas" <heikki@enterprisedb.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Symbolic Links to Tablespaces
Next
From: "Campbell, Lance"
Date:
Subject: Re: Symbolic Links to Tablespaces