Re: Poor performance of delete by primary key - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Poor performance of delete by primary key
Date
Msg-id 431E5958.8040102@familyhealth.com.au
Whole thread Raw
In response to Re: Poor performance of delete by primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Poor performance of delete by primary key
List 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...

Chris

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: poor VACUUM performance on large tables
Next
From: Marc Cousin
Date:
Subject: Re: insert performance for win32