On Fri, Nov 12, 2010 at 9:22 AM, Thom Brown <thom@xxxxxxxxx> wrote: > On 12 November 2010 16:14, Kyriacos Kyriacou <kyriacosk@xxxxxxxxxxxxx> > 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
