Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 079FD1337B97 for ; Fri, 12 Nov 2010 12:43:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 12111-01-6 for ; Fri, 12 Nov 2010 16:43:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from cerber.thunderworx.net (cerber.thunderworx.net [217.27.32.18]) by mail.postgresql.org (Postfix) with ESMTP id 865B61337EA2 for ; Fri, 12 Nov 2010 12:34:03 -0400 (AST) Received: by cerber.thunderworx.net from user; Fri, 12 Nov 2010 18:33:23 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: MVCC performance issue Date: Fri, 12 Nov 2010 18:33:22 +0200 Message-ID: <8BCBF9DB739F034B87FE7C7D30EAE55C279F0552@hqex2k.francoudi.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] MVCC performance issue Thread-Index: AcuChcXxkXnwOH8NTHyU9VLTbMHO+gAAVT3A References: <8BCBF9DB739F034B87FE7C7D30EAE55C279F054F@hqex2k.francoudi.com> <8BCBF9DB739F034B87FE7C7D30EAE55C240D4BCA@hqex2k.francoudi.com> <20101112162203.GM14016@aart.is.rice.edu> From: "Kyriacos Kyriacou" To: "Kenneth Marshall" Cc: "Thom Brown" , X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201011/204 X-Sequence-Number: 41228 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@rice.edu]=20 Sent: Friday, November 12, 2010 6:22 PM To: Kyriacos Kyriacou Cc: Thom Brown; pgsql-performance@postgresql.org Subject: Re: [PERFORM] 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: > =20 >=20 > 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!=20 >=20 > I have it in my plans so in next few months I will setup new servers and > upgrade to version 9.=20 >=20 >=20 > >> Which version of PostgreSQL are you basing this on? >=20 > >> > >>--=20 > >>Thom Brown > >>Twitter: @darkixion > >>IRC (freenode): dark_ixion > >>Registered Linux user: #516935 >=20