| From: | denis(at)coralindia(dot)com |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Vacuum again and again |
| Date: | 2002-09-26 05:20:50 |
| Message-ID: | 00a901c2651c$7b110d80$0232a8c0@denis |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi all,
We have a web application which has 15 tables. Out of these, 7 tables has >
400000 records. The client application automatically connects to Postgres
database (at server) after 1 1/2 hours and performs INCREMENTAL UPLOAD to
server from client.
Prob :
Upload option works fine after VACUUM but after 3-4 days, it starts giving
ERRORs... Again, we have to run VACUUM to solve the prob..
So, now a days, it has become our routine to run VACUUM every day to avoid
ERRORs.. caz, when ERROR shown, it causes bad impression on client.
Is there any parameters setting in DATABASE or anything else we can do
(except VACUUM regularly) ?
Postgres 7.2 on Redhat Linux 7.2
Thanx
Denis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aarni Ruuhimäki / Megative Tmi / KYMI.com | 2002-09-26 06:24:02 | Re: Vacuum again and again |
| Previous Message | Doug Silver | 2002-09-25 17:38:24 | Re: Setting primary key on existing table |