| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2008-10-20 18:14:10 | Re: BUG #4487: CLUSTER does not take account of VACUUM statistics |
| Previous Message | Andrew Grillet | 2008-10-20 10:12:17 | BUG #4486: CSV feature request |