pgsql: Add index information to /contrib/pgstattuple: This is an

Поиск
Список
Период
Сортировка
От momjian@postgresql.org (Bruce Momjian)
Тема pgsql: Add index information to /contrib/pgstattuple: This is an
Дата
Msg-id 20060706021807.617DC9FA605@postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Add index information to /contrib/pgstattuple:

This is an extension of pgstattuple to query information from indexes.
It supports btree, hash and gist. Gin is not supported. It scans only
index pages and does not read corresponding heap tuples. Therefore,
'dead_tuple' means the number of tuples with LP_DELETE flag.

Also, I added an experimental feature for btree indexes. It checks
fragmentation factor of indexes. If an leaf has the right link on the
next adjacent page in the file, it is assumed to be continuous (not
fragmented). It will help us to decide when to REINDEX.

ITAGAKI Takahiro

Modified Files:
--------------
    pgsql/contrib/pgstattuple:
        README.pgstattuple (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgstattuple/README.pgstattuple.diff?r1=1.7&r2=1.8)
        README.pgstattuple.euc_jp (r1.6 -> r1.7)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp.diff?r1=1.6&r2=1.7)
        pgstattuple.c (r1.21 -> r1.22)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgstattuple/pgstattuple.c.diff?r1=1.21&r2=1.22)

В списке pgsql-committers по дате отправления:

Предыдущее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: WIN32 fixes: I take out patch for this as a promise.
Следующее
От: jzhang@pgfoundry.org (User Jzhang)
Дата:
Сообщение: bizgres - bizgres: Added the support for multi-column bitmap indexes,