Postgres Pro
Downloads
Home   >   mailing lists

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

From Heikki Linnakangas
Subject Re: I/O on select count(*)
Date
Msg-id 483AB515.5050201@enterprisedb.com
Whole thread Raw
In response to Re: I/O on select count(*)  (Decibel! <decibel@decibel.org>)
Responses Re: I/O on select count(*)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: Posible planner improvement?
Next
From: "Campbell, Lance"
Date:
Subject: Symbolic Links to Tablespaces