B-trees (Indexes) storage space

Started by Tourtounis Sotirisover 23 years ago2 messagesgeneral
Jump to latest
#1Tourtounis Sotiris
tourtoun@csd.uoc.gr

How can i measure the storage space of the b-trees that i create on a
database after the loading of the data on it? Is there any specific
command?

SWTHRHS TOYRTOYNHS
(tourtoun@csd.uch.gr)

#2Bruce Momjian
bruce@momjian.us
In reply to: Tourtounis Sotiris (#1)
Re: B-trees (Indexes) storage space

Tourtounis Sotiris wrote:

How can i measure the storage space of the b-trees that i create on a
database after the loading of the data on it? Is there any specific
command?

The 7.2.X documentation didn't cover this but 7.3 does:

http://developer.postgresql.org/docs/postgres/diskusage.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026