Thread: B-trees (Indexes) storage space

B-trees (Indexes) storage space

From
Tourtounis Sotiris
Date:
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)



Re: B-trees (Indexes) storage space

From
Bruce Momjian
Date:
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