> Personally I would prefer to have a trigger on a metadata table
> where I could
> trigger vacuuming a particular table each n number of
> transactions(Oh it would
> be great if that vacuum runs in background not blocking meta data
> table.. just
> a wishlist...). Can anybody tell me which table I could write
> such a trigger? I
> went thr. pg_* for some time but didn't find what I was looking for..
Actually, if you wrote it in C and kept some static data on each table, you
could probably write a vacuum trigger pretty easily. You could even keep
the info in a table.
Chris