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