DELETE error - Memory exhausted in AllocSetAlloc

From: j sk <jsk817(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: DELETE error - Memory exhausted in AllocSetAlloc
Date: 2003-10-15 00:58:21
Message-ID: 20031015005821.41362.qmail@web20503.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,
While trying to delete ~8000 rows from a table which
has about 10 foreign keys and are triggered to cascade
on delete, I get this error:

ERROR: Memory exhausted AllocSetAlloc(1124)

Im running PG7.3.4 with 256MB memory.

I looked up this info but 'ulimit' and 'limit' arent
available:
http://www.postgresql.org/docs/faqs/FAQ.html#4.18

Please let me know if theres any solution. If no real
solution, Im planning to delete rows in chunks of 100
or 500 at a time thru a stored function.

Thanks

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Carleton 2003-10-15 01:10:52 working with users
Previous Message Sam Carleton 2003-10-15 00:51:33 Error compiling 7.3.4 on Solaris 8