Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuuming and re-indexing (was Re: Vacuum meaning) - Mailing list pgsql-admin

From Jeff Boes
Subject Re: Vacuuming and re-indexing (was Re: Vacuum meaning)
Date
Msg-id avkp97$2k61$1@news.hub.org
Whole thread Raw
In response to Vacuuming and re-indexing (was Re: Vacuum meaning)  ("David F. Skoll" <dfs@roaringpenguin.com>)
List pgsql-admin
Tree view 
On Fri, 03 Jan 2003 10:19:44 -0500, David F. Skoll wrote:

> Is there any way to adaptively vacuum the database?  By this, I mean is
> it possible to run a query every few minutes and decide to vacuum based
> on the query results?

You may want to investigate this:

http://gborg.postgresql.org/project/pgavd/projdisplay.php

I started to, but haven't had the time to really dig into it.



--
Jeff Boes                                      vox 616.226.9550 ext 24
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise

pgsql-admin by date:

Previous
From: Peter Schuller
Date:
Subject: Re: Password authentication disabled due to MD5 usage
Next
From: "Campano, Troy"
Date:
Subject: FW: [GENERAL] shell script when a user logs in