Idea for vacuuming

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Idea for vacuuming
Date: 2006-06-23 00:12:36
Message-ID: e7fble$2per$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running a 8.0 database. I have a very large log table that is
rarely updated or deleted from. The nightly vacuum does not know this,
and spends a lot of time on it, and all its indexes.

My RFE: When vacuuming a table, pg should try to vacuum the primary key
first. If that results in 0 recovered entries, then assume the table
has no updates/deletes and skip the rest of that table. I'm picking the
primary key here, but any index that indexes each row of the table will
do. Maybe it should just pick the smallest index that indexes each row
of the table.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2006-06-23 01:04:38 Re: aggregate of bitstrings
Previous Message Tom Lane 2006-06-22 21:54:33 Re: autovacuum template0