Re: [GENERAL] DELETE eats up all memory and crashes box

2006-10-06 Thread Worky Workerson
Note that whether you have CASCADE or not is not the issue --- if you are doing a delete in a foreign-key-referenced relation at all, you are going to have a trigger event per deleted row no matter what the details of the FK are. So the best/fastest* way to do this would be to remove the FK rela

Re: [GENERAL] DELETE eats up all memory and crashes box

2006-10-06 Thread Tom Lane
"Worky Workerson" <[EMAIL PROTECTED]> writes: > On 10/6/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> Well, the memory eating is easy to explain: pending-trigger-event list. > Is there any way to tune PG to execute such a query, or am I forced to > forgo the convenience of the "ON DELETE CASCADE" and

Re: [GENERAL] DELETE eats up all memory and crashes box

2006-10-06 Thread Worky Workerson
On 10/6/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Worky Workerson" <[EMAIL PROTECTED]> writes: > When I issue a fairly large DELETE query which has multiple tables > with FOREIGN KEY CASCADE on them, Postgres eats up *all* the > memory on my system and the system crashes. Well, the memory ea

Re: [GENERAL] DELETE eats up all memory and crashes box

2006-10-06 Thread Tom Lane
"Worky Workerson" <[EMAIL PROTECTED]> writes: > When I issue a fairly large DELETE query which has multiple tables > with FOREIGN KEY CASCADE on them, Postgres eats up *all* the > memory on my system and the system crashes. Well, the memory eating is easy to explain: pending-trigger-event lis

[GENERAL] DELETE eats up all memory and crashes box

2006-10-06 Thread Worky Workerson
When I issue a fairly large DELETE query which has multiple tables with FOREIGN KEY CASCADE on them, Postgres eats up *all* the memory on my system and the system crashes. I figure that there are two problems, one is PG eating up all of the memory, the other is the system crashing and not te