From: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
---|---|
To: | "'Michael Paquier'" <michael(dot)paquier(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: how to extract the page "address" from the ctid |
Date: | 2015-07-01 09:21:36 |
Message-ID: | B6F6FD62F2624C4C9916AC0175D56D8828BEBFC1@jenmbs01.ad.intershop.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: Michael Paquier [mailto:michael(dot)paquier(at)gmail(dot)com]
> Sent: Mittwoch, 1. Juli 2015 07:05
> To: Marc Mamin
> Cc: Postgres General
> Subject: Re: [GENERAL] how to extract the page "address" from the ctid
>
> On Tue, Jun 30, 2015 at 10:56 PM, Marc Mamin <M(dot)Mamin(at)intershop(dot)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
As I understand it, pageinspect allows to get insight in given pages,
but not to compute overall page distribution analysis of given values.
There is a function tidsend(tid) that seems to return a row position within a block, but no equivalent to return the block position.
I'm fine with my regexp [ substring(ctid::text, '^.([^,]+)') ], but was just wondering if there were a more efficient way for it.
This could be a small nice to have e.g. in pageinspect.
regards,
Marc Mamin
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Mamin | 2015-07-01 09:33:43 | Re: Systemd vs logging collector |
Previous Message | Urs Berner | 2015-07-01 09:05:51 | Re: Ubuntu 14.04 LTS install problem |