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
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.