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
