postmaster hangs on delete from

From: emsa(at)devdep(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: postmaster hangs on delete from
Date: 2009-03-13 13:10:12
Message-ID: 6022.194.103.63.154.1236949812.squirrel@www.devdep.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2009-03-13 13:21:10 Inserting string with a " into an array using {} syntax ... possible?
Previous Message Simon Riggs 2009-03-13 12:21:23 Re: I don't want to back up index files