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

Re: Poor performance of delete by primary key

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Brian Choate <brianc(at)nimblefish(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance of delete by primary key
Date: 2005-09-07 03:07:04
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
> Unfortunately there's no very simple way to determine which FK is the
> problem.  (In 8.1 it'll be possible to do that with EXPLAIN ANALYZE,
> but in existing releases EXPLAIN doesn't break out the time spent in
> each trigger ...)  You have to just eyeball the schema :-(.

phpPgAdmin has a handy info feature where you can see all tables that 
refer to the current one.  You can always go and steal that query to 
find them...


In response to


pgsql-performance by date

Next:From: Christian.KastnerDate: 2005-09-07 09:04:43
Subject: Re: Postgresql Hardware - Recommendations
Previous:From: Tom LaneDate: 2005-09-07 01:07:27
Subject: Re: poor VACUUM performance on large tables

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