BUG #4487: CLUSTER does not take account of VACUUM statistics
The following bug has been logged online:
Bug reference: 4487
Logged by: anonymous
Email address: noreply@postgresql.org
PostgreSQL version: 8.3
Operating system: BSD
Description: CLUSTER does not take account of VACUUM statistics
Details:
CLUSTER still does a full page scan although there are 0 dead rows on table.
Reproduction:
1. CREATE table
2. INSERT records (e.g. bulk load)
3. VACUUM ANALYZE table
4. CLUSTER table
Expected behavior:
in step 4 clustering starts from first dead page only.
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