Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel
От | Alexander Korotkov |
---|---|
Тема | Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel |
Дата | |
Msg-id | CAPpHfdudTUgh4hiwW_FgsNj875u+JEGoQ7YxeKCRLgE6DpmH9A@mail.gmail.com обсуждение исходный текст |
Ответ на | [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiST indexes fromgevel (Alexey Chernyshov <a.chernyshov@postgrespro.ru>) |
Ответы |
Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel
|
Список | pgsql-hackers |
Hi, Alexey!
On Fri, Jul 21, 2017 at 3:05 PM, Alexey Chernyshov <a.chernyshov@postgrespro.ru> wrote:
the following patch transfers functionality from gevel module
(http://www.sai.msu.su/~megera/wiki/Gevel) which provides functions for
analyzing GIN and GiST indexes to pageinspect. Gevel was originally
designed by Oleg Bartunov, and Teodor Sigaev for developers of GiST and
GIN indexes.
It's very good that you've picked up this work! pageinspect is lacking of this functionality.
Functions added:
- gist_stat(text) - shows statistics on GiST Tree
- gist_tree(text) - shows GiST tree
- gist_tree(text, int4) - shows GiST tree up to MAXLEVEL
- gist_print(text) - prints objects stored in GiST tree
- spgist_stat(text) - shows statistics on SP-GiST
- spgist_print(text) - prints objects stored in index
- gin_value_count() - originally gin_stat(text) - prints estimated counts
for index values
- gin_stats() - originally gin_statpage(text) - shows statistics
- gin_count_estimate(text, tsquery) - shows number of indexed rows matched
query
Tests also transferred, docs for new functions are added. I run pgindent
over the code, but the result is different from those I expected, so I leave
pgindented one.
The patch is applicable to the commit 866f4a7c210857aa342bf901558d170325094dde.
As we can see, gevel contains functions which analyze the whole index. pageinspect is written in another manner: it gives you functionality to analyze individual pages, tuples and so on.
Thus, we probably shouldn't try to move gevel functions to pageinspect "as is". They should be rewritten in more granular manner as well as other pageinspact functions are. Any other opinions?
------
Alexander Korotkov
Postgres Professional: http://www. postgrespro.com
The Russian Postgres Company
Alexander Korotkov
Postgres Professional: http://www.
The Russian Postgres Company
В списке pgsql-hackers по дате отправления: