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

Re: Re: dramatic slowdown. . .fixed by vacuum

From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: Joe Slag <jslag(at)visi(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Re: dramatic slowdown. . .fixed by vacuum
Date: 2000-07-21 21:35:47
Message-ID: 3978C233.FB8D8DFC@catalyst.net.nz (view raw or flat)
Thread:
Lists: pgsql-novice
Joe Slag wrote:
> 
> I see in the docs the suggestion:
> 
>     We recommend that active production databases be VACUUMM-ed nightly
> 
> Is this how people tend to do their vacuuming?  Does anyone do programmatic
> vacuums instead of / in addition to a nightly run?  Is vacuuming mainly
> necessary after big deletes, or are there other common situations
> requiring it?

I run vacuum more often than daily on a few tables which have frequent
updates and where I can handle the table lock for the necessary length
of time.

Cheers,
					Andrew
-- 
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2000-07-21 22:05:59
Subject: Re: [NOVICE] pg_dump problem
Previous:From: The Hermit HackerDate: 2000-07-21 20:20:23
Subject: Re: Re: dramatic slowdown. . .fixed by vacuum

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