Postgres Pro
Downloads
Home   >   mailing lists

Re: Need to run CLUSTER to keep performance - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Need to run CLUSTER to keep performance
Date
Msg-id 47389564.6010602@enterprisedb.com
Whole thread Raw
In response to Re: Need to run CLUSTER to keep performance  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view 
Scott Marlowe wrote:
> On Nov 12, 2007 11:01 AM, Heikki Linnakangas <heikki@enterprisedb.com> wrote:
>> Scott Marlowe wrote:
>>> So, between the first and second vacuum you had a long running
>>> transaction that finally ended and let you clean up the dead rows.
>> No, before 8.3, CLUSTER throws away non-removable dead tuples. So the
>> long running transaction might still be there.
>
> Wow, good to know.  Why would it have changed in 8.3?  Was it
> considered broken behaviour?

I certainly considered it broken, though it was a known issue all along.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Need to run CLUSTER to keep performance
Next
From: Dave Cramer
Date:
Subject: Re: difference between a unique constraint and a unique index ???