Vacuuming and already vacuumed table?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Vacuuming and already vacuumed table?
Date: 2003-08-28 20:53:01
Message-ID: 20030828205301.GZ13329@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

Would it make sense for vacuum to keep a list of 'last vacuumed' or
similar so that it doesn't vacuum a table which hasn't changed since
the last time it was vacuum'd? Seems to me that would be a pretty
simple optimization which would help out alot on systems which have
both a large set of tables which are relatively static and data which
changes a great deal. This is especially true for vacuum full which
also locks the table.

Thoughts?

Thanks,

Stephen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-08-28 21:00:02 Re: Replication Ideas
Previous Message scott.marlowe 2003-08-28 20:21:10 Re: Functions have 32 args limt ???