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.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2006-03-15 19:24:38|
|Subject: Re: ESTERROR |
|Previous:||From: Michael Guerin||Date: 2006-03-15 17:57:25|
|Subject: Re: ESTERROR|