Re: Vacuum again and again - Mailing list pgsql-novice

From AarniRuuhimäki / Megative Tmi / KYMI.com
Subject Re: Vacuum again and again
Date
Msg-id 20020926062709.ONXD28788.fep06.tmt.tele.fi@there
Whole thread Raw
In response to Vacuum again and again  (denis@coralindia.com)
List pgsql-novice
Hi !

We do vacuumall (and dumpall) with a cronjob every night.

BR,

aarni


On Thursday 26 September 2002 08:20 am, you wrote:
> 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
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster



pgsql-novice by date:

Previous
From: denis@coralindia.com
Date:
Subject: Vacuum again and again
Next
From: Stéphane Pinel
Date:
Subject: Best way to install PostgreSQL, libpq etc..on Jaguar (OS X)