From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Rafael Martinez <r.m.guerrero@usit.uio.no>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Vacuum Problems
Date: Wed, 26 Nov 2008 15:21:39 -0200
Message-ID: <3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10811260740m69f8969bt36be6ae675620dcb@mail.gmail.com>
References: <3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com>
<492D5C87.5090505@usit.uio.no>
<3a0028490811260700w6e8d9d86o24effbe0bea2bddb@mail.gmail.com>
<dcc563d10811260740m69f8969bt36be6ae675620dcb@mail.gmail.com>
I'm not using autovacuum. Regular vacuum goes ok.To see the last 10 lines of
verbose i will need to run vacuum tonight
If a run a reindex before the vacuum full, increase the "speed" of doing
vacuum? I found something about it googling.
2008/11/26 Scott Marlowe <scott.marlowe@gmail.com>
> 2008/11/26 Rafael Domiciano <rafael.domiciano@gmail.com>:
> > The database has around 40 Gb.
> > If I not use vacuum full everyday the database get very slow.
> >
> > There is no deadlock on the database.
>
> You didn't mention if you were using autovacuum or not. You also
> didn't mention whether or not you'd tried regular vacuums if for some
> reason you can't use autovacuum. Vacuum full is very intrusive and
> can cause index bloat. It's more of a repair operation than a routine
> maintenance one.
>
> What do the last 10 or so lines of vacuum verbose run as a super user say?
>
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: rafael.domiciano@gmail.com, scott.marlowe@gmail.com, r.m.guerrero@usit.uio.no
Subject: Re: Vacuum Problems
In-Reply-To: <3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com>
* 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