Re: how to extract the page "address" from the ctid - Mailing list pgsql-general

From Michael Paquier
Subject Re: how to extract the page "address" from the ctid
Date
Msg-id CAB7nPqQAv-izLpZ4U-0mERdaxQTrU2eAXdodoEYJUoht528dvA@mail.gmail.com
Whole thread Raw
In response to how to extract the page "address" from the ctid  (Marc Mamin <M.Mamin@intershop.de>)
Responses Re: how to extract the page "address" from the ctid  (Marc Mamin <M.Mamin@intershop.de>)
List 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 by date:

Previous
From: Andy Erskine
Date:
Subject: Streaming Questions and Sizing
Next
From: Urs Berner
Date:
Subject: Ubuntu 14.04 LTS install problem