Re: Unbearably slow cascading deletes

From: andrew(at)pillette(dot)com
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Unbearably slow cascading deletes
Date: 2004-07-20 19:59:40
Message-ID: 200407201959.i6KJxe908906@pillette.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

PREPARE c(int4) AS DELETE FROM childtable WHERE fk=$1;
EXPLAIN EXECUTE c(-1);

gives an index scan.

PREPARE c2(int4) AS DELETE FROM parenttable WHERE key=$1;
EXPLAIN EXECUTE c2(1);

gives a seq scan on the parent table (itself a little curious) and no explanation of what the triggers are doing.

Browse pgsql-performance by date

  From Date Subject
Next Message andrew 2004-07-20 20:06:46 Re: Unbearably slow cascading deletes
Previous Message Stephan Szabo 2004-07-20 19:55:14 Re: Unbearably slow cascading deletes