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

From Marti Raudsepp
Subject Re: Really really slow select count(*)
Date
Msg-id AANLkTin=oEUV1H+WrFAsvtXt3=XVkrx7HmXhOoVSrgnP@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(*)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
On Tue, Feb 8, 2011 at 22:09, Greg Smith <greg@2ndquadrant.com> wrote:
> 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

True, I've hit that a few times too.

Seems that a better solution would be implementing a new -m option
that does this transparently?

Regards,
Marti

pgsql-performance by date:

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