Memory exhausted on DELETE. - Mailing list pgsql-general

From
Subject Memory exhausted on DELETE.
Date
Msg-id slrncnnqrk.3v5.jbi130@nimrod.unx.ca
Whole thread Raw
Responses Re: Memory exhausted on DELETE.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I have a table with about 1,400,000 rows in it.  Each DELETE cascades to
about 7 tables.  When I do a 'DELETE FROM events' I get the following
error:

  ERROR:  Memory exhausted in AllocSetAlloc(84)

I'm running a default install.  What postgres options to I need
to tweak to get this delete to work?

Also, if my tables grows to 30,000,000 rows will the same tweaks
still work?  Or do I have to use a different delete strategy, such
as deleting 1000 rows at a time.

Thanks.


pgsql-general by date:

Previous
From: Karim Nassar
Date:
Subject: Re: Duplicating a database
Next
From: stig erikson
Date:
Subject: Re: The data directory was initialized by PostgreSQL version 7.3,