Skip site navigation (1) Skip section navigation (2)

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

From: "anonymous" <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4487: CLUSTER does not take account of VACUUM statistics
Date: 2008-10-20 17:08:12
Message-ID: 200810201708.m9KH8CtH085832@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4487
Logged by:          anonymous
Email address:      noreply(at)postgresql(dot)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.

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2008-10-20 18:14:10
Subject: Re: BUG #4487: CLUSTER does not take account of VACUUM statistics
Previous:From: Andrew GrilletDate: 2008-10-20 10:12:17
Subject: BUG #4486: CSV feature request

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group