[HACKERS] pageinspect and hash indexes

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема [HACKERS] pageinspect and hash indexes
Дата
Msg-id CAMkU=1y6NjKmqbJ8wLMhr=F74WzcMALYWcVFhEpm7i=mV=XsOg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] pageinspect and hash indexes  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Re: [HACKERS] pageinspect and hash indexes  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения
While trying to figure out some bloating in the newly logged hash indexes, I'm looking into the type of each page in the index.  But I get an error:

psql -p 9876 -c "select hash_page_type(get_raw_page('foo_index_idx',x)) from generate_series(1650,1650) f(x)"

ERROR:  page is not a hash page
DETAIL:  Expected 0000ff80, got 00000000.

The contents of the page are:

\xa4000000d8f203bf65c900001800f01ff01f0420...

(where the elided characters at the end are all zero)

What kind of page is that actually?  And isn't it unhelpful to have the pageinspect module throw errors, rather than returning a dummy value to indicate there was an error?

Thanks,

Jeff

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] [COMMITTERS] pgsql: Use asynchronous connect API in libpqwalreceiver
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless)