summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2006-07-06 02:18:07 +0000
committerBruce Momjian <bruce@momjian.us>2006-07-06 02:18:07 +0000
commitdab42382f483c3070bdce14a4d93c5d0cf61e82b (patch)
tree715002d6044e8b5cb97bf98a0b0f386354f63302 /src
parent591e90a4d9dd5698dd5fd01d0d8620233c326da4 (diff)
downloadpostgresql-dab42382f483c3070bdce14a4d93c5d0cf61e82b.tar.gz
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
Diffstat (limited to 'src')
0 files changed, 0 insertions, 0 deletions