Re: CLUSTER and MVCC - Mailing list pgsql-hackers

From Csaba Nagy
Subject Re: CLUSTER and MVCC
Date
Msg-id 1173446118.9058.83.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: CLUSTER and MVCC  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: CLUSTER and MVCC  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
On Fri, 2007-03-09 at 14:00, Alvaro Herrera wrote:
> But I'm not really seeing the problem here.  Why isn't Csaba's problem
> fixed by the fact that HOT reduces the number of dead tuples in the
> first place?  If it does, then he no longer needs the CLUSTER
> workaround, or at least, he needs it to a much lesser extent.

Is this actually true in the case of HOT + long running transactions ? I
was supposing HOT has the same problems in the presence of long running
transactions...

Cheers,
Csaba.




pgsql-hackers by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: CLUSTER and MVCC
Next
From: Greg Smith
Date:
Subject: Re: Log levels for checkpoint/bgwriter monitoring