Re: BUG #4487: CLUSTER does not take account of VACUUM statistics

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: anonymous <noreply(at)postgresql(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4487: CLUSTER does not take account of VACUUM statistics
Date: 2008-10-20 18:14:10
Message-ID: 48FCCA72.6050904@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

anonymous wrote:
> CLUSTER still does a full page scan although there are 0 dead rows on table.

That's not a bug. Keep in mind that the main purpose of CLUSTER is not
to remove dead tuples, but to reorder the rows.

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Harvey, Allan AC 2008-10-21 02:31:12 Upgrade from 7.4.5 to 8.3.3
Previous Message anonymous 2008-10-20 17:08:12 BUG #4487: CLUSTER does not take account of VACUUM statistics