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

Re: dramatic slowdown. . .fixed by vacuum

From: Joe Slag <jslag(at)visi(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: dramatic slowdown. . .fixed by vacuum
Date: 2000-07-21 19:42:19
Message-ID: 20000721144219.A23144@isis.visi.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, Jul 21, 2000 at 12:36:35PM -0700, WOLF, PATRICK wrote:
> Try running vacuum on the table or the database.  Here's an excerpt from the
> man on vacuum:
> 
[snip]
> 
> 

Thanks to all who responded.  I vacuumed out foo, and sure enough 
the select time is down to 10 seconds again.

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?

Joe Slag
Wagpaw, Inc.

In response to

Responses

pgsql-novice by date

Next:From: Anthony E . GreeneDate: 2000-07-21 20:20:22
Subject: Re: Re: dramatic slowdown. . .fixed by vacuum
Previous:From: John BurskiDate: 2000-07-21 19:38:24
Subject: pg_dump problem

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