Re: Memory Problem

Hi,

On Wed, 02 Jul 2008, Tom Lane <tgl@sss.pgh.pa.us> writes:
> Are there any foreign keys referencing this table?  If so, you're
> probably running out of memory for the list of pending trigger events
> (to verify that the FK constraint isn't violated by the delete).
>
> Allowing the triggers to fire individually would take forever anyway,
> so it might be best to drop the foreign key constraint(s) and then
> re-establish them after the delete.

Thanks for the warning. Temporarily disabling FKs did the job. I knew
the problem about triggers, but didn't expect same applies for FKs
also. I'm very suprised FKs cause memory exhaustion too.


Regards.