Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4487: CLUSTER does not take account of VACUUM statistics - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #4487: CLUSTER does not take account of VACUUM statistics
Date
Msg-id 48FCCA72.6050904@enterprisedb.com
Whole thread Raw
In response to BUG #4487: CLUSTER does not take account of VACUUM statistics  ("anonymous" <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "anonymous"
Date:
Subject: BUG #4487: CLUSTER does not take account of VACUUM statistics
Next
From: "Robert 'BoBsoN' Partyka"
Date:
Subject: BUG #4478: = operator in connection with CASE looks like loose some functionality (bug or feature?)