Re: Hash join on int takes 8..114 seconds

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Hash join on int takes 8..114 seconds
Дата
Msg-id 200811211113.46410@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: Hash join on int takes 8..114 seconds  ("Andrus" <kobruleht2@hot.ee>)
Список pgsql-performance
On Friday 21 November 2008, "Andrus" <kobruleht2@hot.ee> wrote:
> Those commands cause server probably to stop responding to other client
> like vacuum full pg_shdepend
> did.
>
> Should vacuum_cost_delay = 2000 allow other users to work when running
> those commands ?

Any vacuum full or cluster will lock out other clients. A high
vacuum_cost_delay will just make the vacuum run slower.

--
Corporations will ingest natural resources and defecate garbage until all
resources are depleted, debt can no longer be repaid and our money becomes
worthless - Jay Hanson

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

Предыдущее
От: "Andrus"
Дата:
Сообщение: Re: Hash join on int takes 8..114 seconds
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Hash join on int takes 8..114 seconds