Fresh initdb contains a few deleted B-Tree pages

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Fresh initdb contains a few deleted B-Tree pages
Дата
Msg-id CAM3SWZRJFLRMohRUpoVeKtSBwR9h9taQyETNVRv6s8Mu--gMiw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Fresh initdb contains a few deleted B-Tree pages  (Greg Stark <stark@mit.edu>)
Список pgsql-hackers
I would like to put on the record that there are a few deleted B-Tree
pages in a freshly initdb'd database. As my btreecheck tools shows:

mgd=# select bt_index_verify(indexrelid::regclass::text) from pg_index;
NOTICE:  00000: page 12 of index "pg_attribute_relid_attnam_index" is deleted
LOCATION:  bt_page_verify_worker, btreecheck.c:206
NOTICE:  00000: page 13 of index "pg_attribute_relid_attnam_index" is deleted
LOCATION:  bt_page_verify_worker, btreecheck.c:206
NOTICE:  00000: page 14 of index "pg_attribute_relid_attnam_index" is deleted
LOCATION:  bt_page_verify_worker, btreecheck.c:206
NOTICE:  00000: page 9 of index "pg_attribute_relid_attnum_index" is deleted
LOCATION:  bt_page_verify_worker, btreecheck.c:206

(contrib/pageinspect's bt_page_items() will show a similar message if
this is done manually)

This is not a new-to-9.4 issue. I am not suggesting that it's a real
problem that requires immediate fixing, but it is suboptimal. We may
wish to fix this someday.

-- 
Peter Geoghegan



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: WAL format and API changes (9.5)