Rafael Domiciano escribió: > 2008/12/9 Rafael Domiciano <rafael.domiciano@xxxxxxxxx> > > > 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
