Re: Quick select, slow update - help with performance problems

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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql