Re: I/O on select count(*)

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Decibel!" <decibel(at)decibel(dot)org>
Cc: "Greg Smith" <gsmith(at)gregsmith(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: I/O on select count(*)
Date: 2008-05-26 13:03:17
Message-ID: 483AB515.5050201@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Campbell, Lance 2008-05-26 14:11:51 Symbolic Links to Tablespaces
Previous Message ITAGAKI Takahiro 2008-05-26 11:30:00 Re: Posible planner improvement?