From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | Kyriacos Kyriacou <kyriacosk(at)prime-tel(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: MVCC performance issue |
Date: | 2010-11-12 17:27:12 |
Message-ID: | AANLkTinNDtoUoFr-JV7xbX=h1GYNj8pZ0vi=cEna1n-D@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-11-12 17:39:55 | Re: MVCC performance issue |
Previous Message | Kyriacos Kyriacou | 2010-11-12 17:13:14 | Re: MVCC performance issue |