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

Re: Vacuum Problems

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(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 17:21:39
Message-ID: 3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(dot)marlowe(at)gmail(dot)com>

> 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: Vishal AroraDate: 2008-11-26 17:25:11
Subject: Re: PgAgent Job Scehduler is NOT running
Previous:From: Scott MarloweDate: 2008-11-26 15:40:41
Subject: Re: Vacuum Problems

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