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 wrote: > Merlin Moncure writes: >> On Fri, Apr 24, 2009 at 1:01 PM, Josh Trutwin >> 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.  The

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

2009-04-25 Thread Tom Lane
Merlin Moncure writes: > On Fri, Apr 24, 2009 at 1:01 PM, Josh Trutwin > 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 people using 8.1 than 8.3 and 8.1 > ha

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 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 Scott Marlowe
On Fri, Apr 24, 2009 at 11:01 AM, 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.

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 wrote: > On Fri, Apr 24, 2009 at 11:01 AM, 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

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, t

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 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 and I've looked over

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.

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 starts

[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 no