Re: DELETE error - Memory exhausted in AllocSetAlloc

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: j sk <jsk817(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: DELETE error - Memory exhausted in AllocSetAlloc
Date: 2003-10-15 04:11:59
Message-ID: 12526.1066191119@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

j sk <jsk817(at)yahoo(dot)com> writes:
> 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)

Could we see a complete reproducible example? I'm not aware of any
memory leaks in the foreign-key support, but perhaps you've found one...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michelle Murrain 2003-10-15 04:21:55 Re: working with users
Previous Message Bruno Wolff III 2003-10-15 02:41:00 Re: working with users