[HACKERS] [PATCH] Pageinspect - add functions on GIN and GiST indexes fromgevel

Поиск
Список
Период
Сортировка
От Alexey Chernyshov
Тема [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiST indexes fromgevel
Дата
Msg-id accae316-5e4d-8963-0c3d-277ef13c396c@postgrespro.ru
обсуждение исходный текст
Ответы Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel  (Robert Haas <robertmhaas@gmail.com>)
Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiSTindexes from gevel  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
Hi all,

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.

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.

-- 
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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] [PATCH] Make sure all statistics is sent after a fewDML are performed
Следующее
От: Yugo Nagata
Дата:
Сообщение: Re: [HACKERS] xlogfilename