On Tuesday 01 July 2008 12:17, Richard Huxton wrote:
> 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
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 t
Hi folks.
My system is slowing down, more notably over the last few weeks.
The main reason is that it's on an old slow machine, and I'm in the process of
sorting this.
However, I think that there are some issues within my database which I need to
investigate.
There seems to be some performance