Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel - Mailing list pgsql-hackers

From Alexey Chernyshov
Subject Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel
Date
Msg-id 20170913104541.344be2ee@PostgresPro-A-Chernyshov
Whole thread Raw
In response to Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Responses Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel
Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel
List pgsql-hackers
On Sat, 9 Sep 2017 13:53:35 +0530
Ashutosh Sharma <ashu.coek88@gmail.com> wrote:

> 
> Finally, i got some time to look into this patch and surprisingly I
> didn't find any function returning information at page level instead
> all the SQL functions are returning information at index level.
> Therefore, i too feel that it should be either integrated with
> pgstattuple which could a better match as Tomas also mentioned or may
> be add a new contrib module itself. I think, adding a new contrib
> module looks like a better option. The reason being, it doesn't simply
> include the function for showing index level statistics (for e.g..
> index size, no of rows, values..e.t.c) like pgstattuple does but,
> also, displays information contained in a page for e.g. the object
> stored in the page,  it's tid e.t.c. So, more or less, I would say
> that, it's the mixture of pageinspect and pgstattuple module and
> therefore, i feel, adding it as a new extension would be a better
> choice. Thought?

Thank you for your interest, I will add a new contrib module named,
say, indexstat. I think we can add statistics on other indexes in the
future.

-- 
Alexey Chernyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: [HACKERS] Setting pd_lower in GIN metapage
Next
From: Christoph Berg
Date:
Subject: Re: [HACKERS] Surjective functional indexes