Обсуждение: 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