From: Kyriacos Kyriacou <kyriacosk@prime-tel.com>
To: Kenneth Marshall <ktm@rice.edu>
Cc: Thom Brown <thom@linux.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: MVCC performance issue
Date: Fri, 12 Nov 2010 18:33:22 +0200
Message-ID: <8BCBF9DB739F034B87FE7C7D30EAE55C279F0552@hqex2k.francoudi.com> (raw)
References: <8BCBF9DB739F034B87FE7C7D30EAE55C279F054F@hqex2k.francoudi.com>
<AANLkTinhnXGo4SxdHN1b5twy2rguV+1An-XAeDtbnJFi@mail.gmail.com>
<8BCBF9DB739F034B87FE7C7D30EAE55C240D4BCA@hqex2k.francoudi.com>
<20101112162203.GM14016@aart.is.rice.edu>
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]
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:
>
>
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kyriacosk@prime-tel.com, ktm@rice.edu, thom@linux.com
Subject: Re: MVCC performance issue
In-Reply-To: <8BCBF9DB739F034B87FE7C7D30EAE55C279F0552@hqex2k.francoudi.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox