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

From Kevin Grittner
Subject Re: Really really slow select count(*)
Date
Msg-id 4D515F37020000250003A65D@gw.wicourts.gov
Whole thread Raw
In response to Re: Really really slow select count(*)  (Marti Raudsepp <marti@juffo.org>)
List pgsql-performance
Marti Raudsepp <marti@juffo.org> wrote:
> 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.

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

Maybe.  Another option might be to use -t or some new switch (or -t
in combination with some new switch) as a time limit before
escalating to the next shutdown mode.

-Kevin

pgsql-performance by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Really really slow select count(*)
Next
From: Scott Marlowe
Date:
Subject: Re: Really really slow select count(*)