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

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2006-03-15 19:24:38
Subject: Re: ESTERROR
Previous:From: Michael GuerinDate: 2006-03-15 17:57:25
Subject: Re: ESTERROR

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