Re: Vacuuming and re-indexing (was Re: Vacuum meaning)

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuuming and re-indexing (was Re: Vacuum meaning)
Date: 2003-01-09 21:25:57
Message-ID: avkp97$2k61$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rob Abernethy IV 2003-01-10 06:49:27 Encrypted Passwords
Previous Message Peter Schuller 2003-01-09 17:41:19 Re: Password authentication disabled due to MD5 usage