Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
Дата
Msg-id 611.1063310390@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later  ("Clay Luther" <claycle@cisco.com>)
Список pgsql-general
Дерево обсуждения 
"Clay Luther" <claycle@cisco.com> writes:
> Sort_mem is 32K.

Try more (like 32M).  Particularly in 7.4, you can really hobble a query
by starving it for sort memory (since that also determines whether
hashtable techniques will be tried).

            regards, tom lane

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

Предыдущее
От: Sean Chittenden
Дата:
Сообщение: Re: State of Beta 2
Следующее
От: "Clay Luther"
Дата:
Сообщение: Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later