Re: So, is COUNT(*) fast now? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: So, is COUNT(*) fast now?
Date
Msg-id CA+TgmobvqbypH7w_rJhrbMdrg75+R_uMpHbGBJkqSyrCKOJd1w@mail.gmail.com
Whole thread Raw
In response to Re: So, is COUNT(*) fast now?  (Anssi Kääriäinen <anssi.kaariainen@thl.fi>)
List pgsql-hackers
On Mon, Oct 31, 2011 at 9:51 AM, Anssi Kääriäinen
<anssi.kaariainen@thl.fi> wrote:
> Stupid question, but why not keep the whole VM pinned?

It might be that keeping more than one VM page pinned is a good idea,
but we'd have to think carefully about it.  For example, if we pin too
many pages in shared_buffers, other queries could start erroring out
for failure to find an evictable buffer.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Anssi Kääriäinen
Date:
Subject: Re: So, is COUNT(*) fast now?
Next
From: Tom Lane
Date:
Subject: Re: Clarification on item on Todo List