Rafael Domiciano escribió:
> 2008/12/9 Rafael Domiciano <rafael.domiciano@gmail.com>
>
> > Maybe Could be Check-Points? I have changed the parameters sometime ago.
> > Follow:
> > effective_cache_size = 200MB
> >
> > checkpoint_segments = 40 # in logfile segments, min 1, 16MB
> > each
> > checkpoint_timeout = 3min # range 30s-1h
checkpoint_timeout 3 minutes? I think you want to increase that a lot.
> > Now I'm having the following problem on vacuum:
> > vacuumdb: vacuuming of database "Postgres" failed: ERRO: multiple active
> > vacuums for index "PartInd_replicacao_historico_sl_log_2-node-1".
> >
> > But there's no anymore vacuum running.
Something's very wrong here. This shouldn't ever happen. I haven't
followed this thread but you really should investigate this.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.