Rod,
> You have a 8 billion row table with some very high turn over tuples
> (lots of updates to a few thousand rows). A partial or targeted vacuum
> would be best, failing that you kick them off fairly frequently,
> especially if IO isn't really an issue.
Yes, but we don't have partial or targeted vacuums yet. When tablespaces is
finished, presumably the lock would be per tablespace.
--
-Josh BerkusAglio Database SolutionsSan Francisco