By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

Vacuuming and already vacuumed table?

P: n/a
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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/TmutrzgMPqB3kigRAuTSAJoDx5D5tFwL/09K14vY5y8yPOHz/QCghRra
crKHUx//OF9ld6iUCfWpI/c=
=Bvvw
-----END PGP SIGNATURE-----

Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In the last exciting episode, sf****@snowman.net (Stephen Frost) wrote:
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.


See, in 7.4, the "pg_autovacuum" daemon.

It does much what you suggest...
--
(format nil "~S@~S" "cbbrowne" "ntlug.org")
http://www.ntlug.org/~cbbrowne/finances.html
Rules of the Evil Overlord #110. "I will not employ devious schemes
that involve the hero's party getting into my inner sanctum before the
trap is sprung." <http://www.eviloverlord.com/>
Nov 11 '05 #2

P: n/a
On Thu, 2003-08-28 at 16:53, Stephen Frost wrote:
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.


7.4Beta has a contrib module called pg_autovacuum. It attempts to do
exactly what you are talking about. It only vacuums a table that has
had sufficient activity since the last vacuum. It runs as a standalone
daemon. Also, it can be used against 7.3 if that is what you are
running.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.