Re: [GENERAL] Delete fails with out of memory

2009-10-18 Thread Simon Riggs
On Sat, 2009-10-17 at 20:02 -0700, yuliada wrote: > I have a large database and I'm trying to execute delete on a table which > has some related tables. The query fails with following error: > ERROR: out of memory > DETAIL: Failed on request of size 1048576. > > I'm new to postgresql and I'm cu

Re: [GENERAL] Delete fails with out of memory

2009-10-18 Thread Filip Rembiałkowski
2009/10/18 yuliada > > Hello > > I have a large database and I'm trying to execute delete on a table which > has some related tables. The query fails with following error: > ERROR: out of memory > DETAIL: Failed on request of size 1048576. > > I'm new to postgresql and I'm currently trying to f

[GENERAL] Delete fails with out of memory

2009-10-17 Thread yuliada
Hello I have a large database and I'm trying to execute delete on a table which has some related tables. The query fails with following error: ERROR: out of memory DETAIL: Failed on request of size 1048576. I'm new to postgresql and I'm currently trying to figure out what to do by myself. I've