Hi, On Wed, 02 Jul 2008, Tom Lane <tgl@xxxxxxxxxxxxx> 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.
