pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Rafael Domiciano <rafael.domiciano@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Matthew T. O'Connor <matthew@zeut.net>
Cc: Rafael Martinez <r.m.guerrero@usit.uio.no>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Vacuum Problems
Date: Tue, 16 Dec 2008 18:38:41 -0300
Message-ID: <20081216213841.GS4741@alvh.no-ip.org> (raw)
In-Reply-To: <3a0028490812160914v1d6aaa48l8169b0c34cd9c038@mail.gmail.com>
References: <3a0028490812080504x22618c6fxd7df8febaadb1632@mail.gmail.com>
	<dcc563d10812080735h42d94633v46449d9933dd22c@mail.gmail.com>
	<3a0028490812080811r1c8a4756i1a1a514911741def@mail.gmail.com>
	<dcc563d10812080817g5cc14e4bt1b573eb7edfb7e5e@mail.gmail.com>
	<3a0028490812080829t1f485ec3g66626e8c4e2b610c@mail.gmail.com>
	<dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com>
	<3a0028490812080917n170df296kfe33a2733a0d0377@mail.gmail.com>
	<dcc563d10812080928s90e324ch2978ffdd4e586225@mail.gmail.com>
	<3a0028490812090258k247ad8b2j8f9037d35b01390f@mail.gmail.com>
	<3a0028490812160914v1d6aaa48l8169b0c34cd9c038@mail.gmail.com>

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.



view thread (23+ messages)

Message-ID: <20081216213841.GS4741@alvh.no-ip.org>
Permalink:  ../20081216213841.GS4741@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20081216213841.GS4741@alvh.no-ip.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alvherre@commandprompt.com, rafael.domiciano@gmail.com, scott.marlowe@gmail.com, matthew@zeut.net, r.m.guerrero@usit.uio.no
  Subject: Re: Vacuum Problems
  In-Reply-To: <20081216213841.GS4741@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox