Hi Bob,
The "table_version.revision" ("revision" is the same) table has a primary key
on id because of the PK "revision_pkey". Actually at the moment there are only
two rows in the table table_version.revision!
Thanks for the tips about the indexes. I'm still in the development and tuning
process, so I will do some analysis of the index stats to see if they are
indeed redundant.
Cheers,
Jeremy
________________________________________
From: Bob Lunney [[email protected]]
Sent: Friday, 1 April 2011 3:54 a.m.
To: [email protected]; Jeremy Palmer
Subject: Re: [PERFORM] Slow deleting tables with foreign keys
Jeremy,
Does table_revision have a unique index on id? Also, I doubt these two indexes
ever get used:
CREATE INDEX idx_crs_action_expired_created
ON table_version.bde_crs_action_revision
USING btree
(_revision_expired, _revision_created);
CREATE INDEX idx_crs_action_expired_key
ON table_version.bde_crs_action_revision
USING btree
(_revision_expired, audit_id);
Bob Lunney
______________________________________________________________________________________________________
This message contains information, which is confidential and may be subject to
legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate,
distribute or copy this message.
If you have received this message in error, please notify us immediately (Phone
0800 665 463 or [email protected]) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any
attachments, after its transmission from LINZ.
Thank you.
______________________________________________________________________________________________________
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
