Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-25 Thread Merlin Moncure
On Fri, Apr 24, 2009 at 1:01 PM, Josh Trutwin j...@trutwins.homeip.net wrote: I've been asked to put together a list of reasons to upgrade a db from 8.1 to 8.3 and I've looked over the changelog, but they want a bullet list of 4-5 top things.  I'm curious what others would say the most 5

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-25 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Fri, Apr 24, 2009 at 1:01 PM, Josh Trutwin j...@trutwins.homeip.net wrote: Sorry this is so vague, I'm frustrated with this request as I figured just the amount of bug-fixes alone would be adequate reasoning. It's not. There are probably more

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-25 Thread Merlin Moncure
On Sat, Apr 25, 2009 at 11:28 AM, Tom Lane t...@sss.pgh.pa.us wrote: Merlin Moncure mmonc...@gmail.com writes: On Fri, Apr 24, 2009 at 1:01 PM, Josh Trutwin j...@trutwins.homeip.net wrote: Sorry this is so vague, I'm frustrated with this request as I figured just the amount of bug-fixes

[GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-24 Thread Josh Trutwin
I've been asked to put together a list of reasons to upgrade a db from 8.1 to 8.3 and I've looked over the changelog, but they want a bullet list of 4-5 top things. I'm curious what others would say the most 5 important updates from 8.1 to 8.3 are. I can say performance improvevents but I'm not

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-24 Thread Joao Ferreira gmail
pg 8.1.4 has a very ugly bug which prevents VACUUM and AUTOVACUUM from performing well I certain situations the AUTOVACUUM will start failing and any VACUUM operations will fail too. solution I found was to periodically REINDEX my tables and INDEXES. the major effect of this bug is Pg

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-24 Thread Brad Nicholson
On Fri, 2009-04-24 at 12:01 -0500, Josh Trutwin wrote: I've been asked to put together a list of reasons to upgrade a db from 8.1 to 8.3 and I've looked over the changelog, but they want a bullet list of 4-5 top things. I'm curious what others would say the most 5 important updates from 8.1

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-24 Thread Josh Trutwin
Thanks for all the replies, I'm picking this one to reply to. Winner! On Fri, 24 Apr 2009 13:40:29 -0400 Brad Nicholson bnich...@ca.afilias.info wrote: On Fri, 2009-04-24 at 12:01 -0500, Josh Trutwin wrote: I've been asked to put together a list of reasons to upgrade a db from 8.1 to 8.3

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-24 Thread Greg Smith
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,

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-24 Thread Ivan Sergio Borgonovo
On Fri, 24 Apr 2009 13:03:06 -0600 Scott Marlowe scott.marl...@gmail.com wrote: On Fri, Apr 24, 2009 at 11:01 AM, Josh Trutwin j...@trutwins.homeip.net wrote: I've been asked to put together a list of reasons to upgrade a db from 8.1 to 8.3 and I've looked over the changelog, but they

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-24 Thread Scott Marlowe
On Fri, Apr 24, 2009 at 11:01 AM, Josh Trutwin j...@trutwins.homeip.net wrote: I've been asked to put together a list of reasons to upgrade a db from 8.1 to 8.3 and I've looked over the changelog, but they want a bullet list of 4-5 top things.  I'm curious what others would say the most 5