Re: Really really slow select count(*)

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: Really really slow select count(*)
Дата
Msg-id AANLkTin=oEUV1H+WrFAsvtXt3=XVkrx7HmXhOoVSrgnP@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Really really slow select count(*)  (Greg Smith <greg@2ndquadrant.com>)
Ответы Re: Really really slow select count(*)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Really really slow select count(*)
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Really really slow select count(*)