From: | Együd Csaba <csegyud(at)vnet(dot)hu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps |
Date: | 2005-06-13 20:27:31 |
Message-ID: | 0II10012RI5VBJ@mail.vnet.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
there is a very intensively used database. The "usage" means that there are
many-many changes in it. It is 24/7 application.
One table is used to insert 200+ rows per minute from a datacolletor driver
application. 200+ deletions are also performed on the same table. It is very
very important to complete the insertions within the one minute.
In other tables there are 56 rows inserted per minute and 224 updates are
performed.
Because of the quick gowing of the tables the old rows are rotated out from
the "production" tables into archive tables on a daily basis. Archive tables
are for select only. This rotation means ~76000 delete per day from the
"production" tables.
The critical tables are vacuum analyzed in every hour. (Not vacuum full
because of the several minutes long exclusive lock)
Earlier the system had been running for 3 months without problems, but a few
weeks ago suddenly it got slower and slower. By now I have to vacuum full
analyze the whole database almost every day to achieve the requested
performance.
The operating system is a Win2k adv. server, on a HP NetServer LC2000
(2xPIII1GHz + 2x36GB SCSI RAID1; 1GB RAM)
I know that Windows is blame... etc., but what about that 3 months perfect
runtime?
What could cause this issue?
Many thanks in advance.
Bye,
-- Csaba Együd
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.9 - Release Date: 2005.06.11.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.9 - Release Date: 2005.06.11.
From | Date | Subject | |
---|---|---|---|
Next Message | David Mitchell | 2005-06-13 20:37:38 | Index problem |
Previous Message | Douglas McNaught | 2005-06-13 20:15:43 | Re: Index does not working. |