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@gregsmith.com http://www.gregsmith.com Baltimore, MD