postmaster hangs on delete from - Mailing list pgsql-general

From emsa@devdep.com
Subject postmaster hangs on delete from
Date
Msg-id 6022.194.103.63.154.1236949812.squirrel@www.devdep.com
Whole thread Raw
Responses Re: postmaster hangs on delete from  (Alan Hodgson <ahodgson@simkin.ca>)
List 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 by date:

Previous
From: Jasid ZA
Date:
Subject: Transactions in user defined function
Next
From: Bill Moran
Date:
Subject: Re: Inserting string with a " into an array using {} syntax ... possible?