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 issues with updating the database. I
have a
select, an insert and an update based on the same table and condition.
The select:
select count(ud_id)
from used_diary
where ud_valet_completed is null and
ud_valet_required < CURRENT_DATE-'7 days'::interval;
completed in about a second. The insert
insert into used_diary_log (ul_u_id, ul_ud_id, ul_changes)
select 25, ud_id, 'Valet automatically cleared down'
from used_diary
where ud_valet_completed is null and
ud_valet_required < CURRENT_DATE-'7 days'::interval;
also completed in about a second. However the update
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.
Could I have any suggestions on how I could start looking into why this
is.
Could it be the config of postgresql, issues with my schema, or something
else?
Gary
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
--
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
|
