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

Re: Vacuum again and again

From: Aarni Ruuhimäki / Megative Tmi / KYMI(dot)com <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: denis(at)coralindia(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Vacuum again and again
Date: 2002-09-26 06:24:02
Message-ID: 20020926062709.ONXD28788.fep06.tmt.tele.fi@there (view raw or flat)
Thread:
Lists: 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



In response to

pgsql-novice by date

Next:From: St=?ISO-8859-1?B?6Q==?=phane PinelDate: 2002-09-26 06:37:08
Subject: Best way to install PostgreSQL, libpq etc..on Jaguar (OS X)
Previous:From: denisDate: 2002-09-26 05:20:50
Subject: Vacuum again and again

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