Re: how to extract the page "address" from the ctid

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: how to extract the page "address" from the ctid
Дата
Msg-id CAB7nPqQAv-izLpZ4U-0mERdaxQTrU2eAXdodoEYJUoht528dvA@mail.gmail.com
обсуждение исходный текст
Ответ на how to extract the page "address" from the ctid  (Marc Mamin <M.Mamin@intershop.de>)
Ответы Re: how to extract the page "address" from the ctid  (Marc Mamin <M.Mamin@intershop.de>)
Список pgsql-general
On Tue, Jun 30, 2015 at 10:56 PM, Marc Mamin <M.Mamin@intershop.de> wrote:
> while waiting for the new BRIN and improved GIN Indexes :-)
>
> I'd like to get a rough feeling, how some column's values are distributed on the internal pages.
> Is there a quicker way to extract the page reference from the ctid?

Isn't it something that pageinspect can do directly for you? It has
been extended for brin indexes.
http://www.postgresql.org/docs/devel/static/pageinspect.html
--
Michael


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

Предыдущее
От: Andy Erskine
Дата:
Сообщение: Streaming Questions and Sizing
Следующее
От: Urs Berner
Дата:
Сообщение: Ubuntu 14.04 LTS install problem