Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 490B21336971 for ; Fri, 12 Nov 2010 12:14:16 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 65039-04 for ; Fri, 12 Nov 2010 16:14:04 +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 50B5E1337B9B for ; Fri, 12 Nov 2010 12:14:04 -0400 (AST) Received: by cerber.thunderworx.net from user; Fri, 12 Nov 2010 18:14:01 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CB8284.9DC215F9" Subject: Re: MVCC performance issue Date: Fri, 12 Nov 2010 18:14:00 +0200 Message-ID: <8BCBF9DB739F034B87FE7C7D30EAE55C240D4BCA@hqex2k.francoudi.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] MVCC performance issue Thread-Index: AcuCcVOht2h92c9OSfK+gG0WaG8BcAAETi2g References: <8BCBF9DB739F034B87FE7C7D30EAE55C279F054F@hqex2k.francoudi.com> From: "Kyriacos Kyriacou" To: "Thom Brown" Cc: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.499 tagged_above=-10 required=5 tests=BAYES_05=-0.5, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201011/196 X-Sequence-Number: 41220 This is a multi-part message in MIME format. ------_=_NextPart_001_01CB8284.9DC215F9 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =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 I have it in my plans so in next few months I will setup new servers and upgrade to version 9.=20 >> Which version of PostgreSQL are you basing this on? >> >>--=20 >>Thom Brown >>Twitter: @darkixion >>IRC (freenode): dark_ixion >>Registered Linux user: #516935 ------_=_NextPart_001_01CB8284.9DC215F9 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------_=_NextPart_001_01CB8284.9DC215F9--