Re: [GENERAL] postmaster hangs on delete from

On Friday 13 March 2009, e...@devdep.com wrote: > 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. > Some possibilities: 1) If it's using 10

[GENERAL] postmaster hangs on delete from

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 r