Re: Really really slow select count(*)

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Really really slow select count(*)
Дата
Msg-id 4D51BED9.3000407@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Really really slow select count(*)  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Really really slow select count(*)  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Scott Marlowe wrote:
> Are there any settings in postgresql.conf that would make it unsafe to
> use -m immediate?
>

Two concerns:

-Clients will be killed without any review, and data related to them lost

-The server will have to go through recovery to start back up again,
which could potentially take a long time.  If you manage a successful
shutdown that doesn't happen.

Shouldn't be unsafe, just has those issues.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books


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

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