Memory exhausted on DELETE.

From: <jbi130(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Memory exhausted on DELETE.
Date: 2004-10-24 17:49:25
Message-ID: slrncnnqrk.3v5.jbi130@nimrod.unx.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Weiss 2004-10-24 20:00:09 Re: Problem with 7.4.1 and complicated queries
Previous Message Bruno Wolff III 2004-10-24 16:17:49 Re: '1 year' = '360 days' ????