Skip site navigation (1) Skip section navigation (2)

Vacuum again and again

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 (view raw or flat)
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






In response to

  • logging at 2002-09-25 00:33:19 from Devinder K Rajput

Responses

pgsql-novice by date

Next:From: Aarni Ruuhimäki / Megative Tmi / KYMI.comDate: 2002-09-26 06:24:02
Subject: Re: Vacuum again and again
Previous:From: Doug SilverDate: 2002-09-25 17:38:24
Subject: Re: Setting primary key on existing table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group