Re: [pgsql-performance] Deletes from tables with foreign keys taking too long

Adam,

> I have a table that has about 200 rows in it.  I have 2 other tables that
> have about 300,000 rows each that reference the first table through a
> foriegn key.  I run a process that rebuilds these tables.  First I delete
> the rows in the large tables (takes about 30 seconds), then I delete the
> the rows in the first table (takes about 5 minutes !!!).  Each of these are
> done in separate transactions.

Not that this answers your performance questions, but you will be able to do 
this faster if you use TRUNCATE instead of DELETE.

-- 
Josh Berkus
josh@agliodbs.com
Aglio Database Solutions
San Francisco