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

Поиск
Список
Период
Сортировка
От anonymous
Тема BUG #4487: CLUSTER does not take account of VACUUM statistics
Дата
Msg-id 200810201708.m9KH8CtH085832@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4487: CLUSTER does not take account of VACUUM statistics  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-bugs
Дерево обсуждения 
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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Andrew Grillet"
Дата:
Сообщение: BUG #4486: CSV feature request
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #4487: CLUSTER does not take account of VACUUM statistics