Re: ESTERROR

From: Michael Guerin <guerin(at)rentec(dot)com>
To: Guido Barosio <gbarosio(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ESTERROR
Date: 2006-03-15 18:02:25
Message-ID: 441856B1.2040404@rentec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Guido Barosio wrote:
> Is the autovacuum running?
> Prolly related tho.
>
No, autovac is not turned on, its not needed b/c the information in the
database is static. If data needs to be changed, the new data is
inserted into a temp table, indexes are created, vacuumed, then the old
table is dropped and the temp table is renamed. Sounds ugly, but its
actually a good solution for the constraints we have.

-mike

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-03-15 19:24:38 Re: ESTERROR
Previous Message Michael Guerin 2006-03-15 17:57:25 Re: ESTERROR