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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Campbell, Lance 2008-05-26 17:10:07 Re: Symbolic Links to Tablespaces
Previous Message Tom Lane 2008-05-26 15:08:51 Re: Symbolic Links to Tablespaces