Re: Really really slow select count(*)

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Really really slow select count(*)
Дата
Msg-id AANLkTikFaJsaR_4M8rw4Wwyu_N+5yx2+7MQOZgXPt-kX@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Really really slow select count(*)  (Greg Smith <greg@2ndquadrant.com>)
Ответы Re: Really really slow select count(*)
Re: Really really slow select count(*)
Список 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 по дате отправления:

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