diff options
author | Magnus Hagander <magnus@hagander.net> | 2007-06-07 09:56:25 +0000 |
---|---|---|
committer | Magnus Hagander <magnus@hagander.net> | 2007-06-07 09:56:25 +0000 |
commit | b13cc9579c73eb2654902e5ce95d50a4e2760d12 (patch) | |
tree | bd9bcb9b169b498c4a624fbdfb6b2d1b9fc287ea | |
parent | 2d4db3675fa7a2f4831b755bc98242421901042f (diff) |
The functions bt_metap, bt_page_stats and bt_page_items had moved
from contrib/pgstattuple to pageinspect. We've already fixed English
documentation, but Japanese version does not catch up.
ITAGAKI Takahiro
-rw-r--r-- | contrib/pgstattuple/README.pgstattuple.euc_jp | 49 |
1 files changed, 1 insertions, 48 deletions
diff --git a/contrib/pgstattuple/README.pgstattuple.euc_jp b/contrib/pgstattuple/README.pgstattuple.euc_jp index 6314365d7fc..15edfb520ca 100644 --- a/contrib/pgstattuple/README.pgstattuple.euc_jp +++ b/contrib/pgstattuple/README.pgstattuple.euc_jp @@ -1,4 +1,4 @@ -$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.8 2006/09/04 03:49:05 momjian Exp $ +$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.9 2007/06/07 09:56:25 mha Exp $ pgstattuple README 2002/08/22 石井達夫 @@ -63,53 +63,6 @@ pgstattuple README 2002/08/22 石井達夫 avg_leaf_density | 50.27 leaf_fragmentation | 0 - bt_metap - -------- - bt_metap() はbtreeインデックスのメタページに関する情報を返却します: - - test=> SELECT * FROM bt_metap('pg_cast_oid_index'); - -[ RECORD 1 ]----- - magic | 340322 - version | 2 - root | 1 - level | 0 - fastroot | 1 - fastlevel | 0 - - bt_page_stats - ------------- - bt_page_stats() は、btreeの単一のページに関する情報を表示します: - - test=> SELECT * FROM bt_page_stats('pg_cast_oid_index', 1); - -[ RECORD 1 ]-+----- - blkno | 1 - type | l - live_items | 256 - dead_items | 0 - avg_item_size | 12 - page_size | 8192 - free_size | 4056 - btpo_prev | 0 - btpo_next | 0 - btpo | 0 - btpo_flags | 3 - - bt_page_items - ------------- - bt_page_items() は、各btreeページの個別のアイテムに関する情報を表示します: - - test=> SELECT * FROM bt_page_items('pg_cast_oid_index', 1); - itemoffset | ctid | itemlen | nulls | vars | data - ------------+---------+---------+-------+------+------------- - 1 | (0,1) | 12 | f | f | 23 27 00 00 - 2 | (0,2) | 12 | f | f | 24 27 00 00 - 3 | (0,3) | 12 | f | f | 25 27 00 00 - 4 | (0,4) | 12 | f | f | 26 27 00 00 - 5 | (0,5) | 12 | f | f | 27 27 00 00 - 6 | (0,6) | 12 | f | f | 28 27 00 00 - 7 | (0,7) | 12 | f | f | 29 27 00 00 - 8 | (0,8) | 12 | f | f | 2a 27 00 00 - 2. pgstattupleのインストール |