To be honest I just now read about HOT (Heap Overflow Tuple) and it seems that will help a lot. Thanks for your point. Kyriacos -----Original Message----- From: Kenneth Marshall [mailto:ktm@xxxxxxxx] Sent: Friday, November 12, 2010 6:22 PM To: Kyriacos Kyriacou Cc: Thom Brown; pgsql-performance@xxxxxxxxxxxxxx Subject: Re: MVCC performance issue Ah, this is a very old version. If you can take advantage of a version with HOT support, you should be much, much happier. Cheers, Ken On Fri, Nov 12, 2010 at 06:14:00PM +0200, Kyriacos Kyriacou 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. > > > >> Which version of PostgreSQL are you basing this on? > > >> > >>-- > >>Thom Brown > >>Twitter: @darkixion > >>IRC (freenode): dark_ixion > >>Registered Linux user: #516935 > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
