From: | "Kyriacos Kyriacou" <kyriacosk(at)prime-tel(dot)com> |
---|---|
To: | "Kenneth Marshall" <ktm(at)rice(dot)edu> |
Cc: | "Thom Brown" <thom(at)linux(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: MVCC performance issue |
Date: | 2010-11-12 16:33:22 |
Message-ID: | 8BCBF9DB739F034B87FE7C7D30EAE55C279F0552@hqex2k.francoudi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)rice(dot)edu]
Sent: Friday, November 12, 2010 6:22 PM
To: Kyriacos Kyriacou
Cc: Thom Brown; pgsql-performance(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-11-12 16:43:05 | Re: anti-join chosen even when slower than old plan |
Previous Message | Robert Haas | 2010-11-12 16:30:24 | Re: anti-join chosen even when slower than old plan |