Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-performance by date

Next:From: andrewDate: 2004-07-20 20:06:46
Subject: Re: Unbearably slow cascading deletes
Previous:From: Stephan SzaboDate: 2004-07-20 19:55:14
Subject: Re: Unbearably slow cascading deletes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group