Re: Really really slow select count(*)

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Really really slow select count(*)
Дата
Msg-id 4D5166BF020000250003A672@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Really really slow select count(*)  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Really really slow select count(*)  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список pgsql-performance
Scott Marlowe <scott.marlowe@gmail.com> 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.

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

I don't think so.  There could definitely be problems if someone
cuts power before your shutdown completes, though.  (I hear that
those firefighters like to cut power to a building before they grab
those big brass nozzles to spray a stream of water into a building.
Go figure...)

-Kevin

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Really really slow select count(*)
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Bad query plan when the wrong data type is used