On Fri, 24 Apr 2009, Scott Marlowe wrote:
Improved vacuuming, including multi-threaded vacuum capability.
That's multi-process vacuum capability; don't you know you can't use the T-word on these lists?
Scott's list is similar to the one I'd come up. To summarize the main items on there, the thing to realize is that 8.1 databases are prone to falling into all sorts of long-term maintenance traps: autovacuum, indexes, checkpoints, and degraded plans can all cause issues that are really hard to resolve on that version. Performance is always better on 8.3, and there's several classes of holes you can fall into with older versions that are either resolved or have useful workarounds now. If your database gets big or the load heavy, you're guaranteed to fall into at least one of them eventually.
http://www.postgresql.org/about/featurematrix should also provide you some ideas for features you might find useful in the newer version.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
