postmaster hangs on delete from

Поиск
Список
Период
Сортировка
От emsa@devdep.com
Тема postmaster hangs on delete from
Дата
Msg-id 6022.194.103.63.154.1236949812.squirrel@www.devdep.com
обсуждение исходный текст
Ответы Re: postmaster hangs on delete from  (Alan Hodgson <ahodgson@simkin.ca>)
Список pgsql-general
Hi,

I have a serious issue with delete from.

When I do something like:

"delete from CALC_INVOICE_DATA where PERIOD_END>='2011-01-01'"

the postmaster takes 100% CPU and then nothing happens.

Doing any type of select on the same table works just fine, I have tried
various forms of vacuums and re-import of data but the result remains the
same.

Does anyone have a clue on what might be wrong here?

/Magnus

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

Предыдущее
От: Jasid ZA
Дата:
Сообщение: Transactions in user defined function
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Inserting string with a " into an array using {} syntax ... possible?