Skip site navigation (1) Skip section navigation (2)

Re: Vacuum Problems

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
Cc: "Rafael Martinez" <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Vacuum Problems
Date: 2008-11-26 15:40:41
Message-ID: dcc563d10811260740m69f8969bt36be6ae675620dcb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
2008/11/26 Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)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?

In response to

Responses

pgsql-admin by date

Next:From: Rafael DomicianoDate: 2008-11-26 17:21:39
Subject: Re: Vacuum Problems
Previous:From: Rafael DomicianoDate: 2008-11-26 15:00:54
Subject: Re: Vacuum Problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group