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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | St=?ISO-8859-1?B?6Q==?=phane Pinel | 2002-09-26 06:37:08 | Best way to install PostgreSQL, libpq etc..on Jaguar (OS X) |
Previous Message | denis | 2002-09-26 05:20:50 | Vacuum again and again |