From: Rafael Martinez <r.m.guerrero@usit.uio.no>
To: Rafael Domiciano <rafael.domiciano@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Vacuum Problems
Date: Wed, 26 Nov 2008 15:26:15 +0100
Message-ID: <492D5C87.5090505@usit.uio.no> (raw)
In-Reply-To: <3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com>
References: <3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com>
Rafael Domiciano wrote:
Hei
> I need some help or just some hints. I am having problems with vacuum
> full in one table only: "clifatura".
> That table has today around 7 million rows.
>
How big is the database?
> I scheduled on the server a cron job to run VACUUM FULL every day at 23
> P.M, but on the following day, at 8 A.M. vacuum is yet working on
> "clifatura"; so I have to kill vacuum.
>
Do you have any locks in this table/database that prevent the vacuum to
be started?
Why do you use VACUUM FULL everyday? This will lock your database until
it finish. I can count with one hand the times we had to run vacuum full
in our systems in the last 6 years.
Use a normal vacuum analyze if 'autovacuum' is not enough for you.
--
Rafael Martinez, <r.m.guerrero@usit.uio.no>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
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: r.m.guerrero@usit.uio.no, rafael.domiciano@gmail.com
Subject: Re: Vacuum Problems
In-Reply-To: <492D5C87.5090505@usit.uio.no>
* 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