Re: ESTERROR - Mailing list pgsql-novice

From Michael Guerin
Subject Re: ESTERROR
Date
Msg-id 441856B1.2040404@rentec.com
Whole thread Raw
In response to Re: ESTERROR  ("Guido Barosio" <gbarosio@gmail.com>)
List 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


pgsql-novice by date:

Previous
From: Michael Guerin
Date:
Subject: Re: ESTERROR
Next
From: Tom Lane
Date:
Subject: Re: ESTERROR