Re: MVCC performance issue

On Fri, Nov 12, 2010 at 9:22 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 12 November 2010 16:14, Kyriacos Kyriacou <kyriacosk(at)prime-tel(dot)com>
> wrote:
>>
>>
>>
>> We are still using PostgreSQL 8.2.4. We are running a 24x7 system and
>> database size is over 200Gb so upgrade is not an easy decision!
>>
>> I have it in my plans so in next few months I will setup new servers and
>> upgrade to version 9.
>
> Everything changed, performance-wise, in 8.3, and there have also been
> improvements since then too.  So rather than completely changing your
> database platform, at least take a look at what work has gone into Postgres
> since the version you're using.

Agreed. 8.3 was a colossal step forward for pg performance. 8.4 was
a huge step ahead in maintenance with on disk fsm. If I was upgrading
from 8.2 today I would go straight to 8.4 and skip 8.3 since it's a
much bigger pain in the butt to configure for fsm stuff.