Re: Really really slow select count(*) - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Really really slow select count(*)
Date
Msg-id AANLkTikFaJsaR_4M8rw4Wwyu_N+5yx2+7MQOZgXPt-kX@mail.gmail.com
Whole thread Raw
In response to Re: Really really slow select count(*)  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: Really really slow select count(*)
Re: Really really slow select count(*)
List pgsql-performance
On Tue, Feb 8, 2011 at 1:09 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> Marti Raudsepp wrote:
>>
>> I couldn't find any past discussions about changing the default to "fast".
>> Are there any reasons why that cannot be done in a future release?
>>
> Kevin and I both suggested a "fast plus timeout then immediate" behavior is
> what many users seem to want.  My comments were at
> http://archives.postgresql.org/pgsql-hackers/2009-09/msg01145.php ; for an
> example of how fast shutdown can fail see
> http://archives.postgresql.org/pgsql-bugs/2009-03/msg00062.php

Are there any settings in postgresql.conf that would make it unsafe to
use -m immediate?

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Really really slow select count(*)
Next
From: "Kevin Grittner"
Date:
Subject: Re: Really really slow select count(*)