The following bug has been logged online: Bug reference: 4487 Logged by: anonymous Email address: [EMAIL PROTECTED] 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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs