Postgres Pro
Downloads
Home   >   mailing lists

Re: Estimate physical index size - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Estimate physical index size
Date
Msg-id 4E6C91CD02000025000410C0@gw.wicourts.gov
Whole thread Raw
In response to Estimate physical index size  (Alejandro <ahmostovoi@gmail.com>)
Responses Re: Estimate physical index size  (Alejandro <ahmostovoi@gmail.com>)
List pgsql-admin
Tree view 
Alejandro  wrote:

> I need to know how to estimate physical index size. I can't find
> any formulas in online documentation.

For an existing index you probably want pg_relation_size():

http://www.postgresql.org/docs/9.0/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE

-Kevin

pgsql-admin by date:

Previous
From: Rural Hunter
Date:
Subject: Re: Backup Question for Point-in-Time Recovery
Next
From: "Kevin Grittner"
Date:
Subject: Re: MSAccess migration to Postgres through ODBC