Vacuuming and already vacuumed table? - Mailing list pgsql-general

From Stephen Frost
Subject Vacuuming and already vacuumed table?
Date
Msg-id 20030828205301.GZ13329@ns.snowman.net
Whole thread Raw
Responses Re: Vacuuming and already vacuumed table?  ("Matthew T. O'Connor" <matthew@zeut.net>)
List 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

Attachment

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: Let's see if this helps ... more anti-virus/anti-spam
Next
From: Tom Lane
Date:
Subject: Re: left outer join terrible slow compared to inner join