Gary Stainburn wrote:
update used_diary set
ud_valet_completed=now(), ud_valet_completed_by=25
where ud_valet_completed is null and
ud_valet_required < CURRENT_DATE-'7 days'::interval
is still running after approx 1 1/2 minutes. I've noticed that other updates
also seem to take a long time.
Do you have any foreign keys referencing used_diary? Do they have the
correct indexes on the referencing tables?
Any on-update triggers?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
