Re: Vacuum Problems

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.