Re: [GENERAL] Poor performance with ON DELETE CASCADE

2007-10-04 Thread Conal
On Sep 27, 4:27 am, [EMAIL PROTECTED] (Tom Lane) wrote: > Conal <[EMAIL PROTECTED]> writes: > > I have a database schema which has a "central" table with several > > others depending on it. The dependent tables all have foreign key > > constraints with ON DELET

[GENERAL] Poor performance with ON DELETE CASCADE

2007-09-26 Thread Conal
I have a database schema which has a "central" table with several others depending on it. The dependent tables all have foreign key constraints with ON DELETE CASCADE so that I can remove tuples from the "central" table and have the dependent rows removed automatically. This all works, but it's ver