Re: Estimate physical index size

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <ahmostovoi(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Estimate physical index size
Date: 2011-09-11 15:47:41
Message-ID: 4E6C91CD02000025000410C0@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-09-11 15:52:28 Re: MSAccess migration to Postgres through ODBC
Previous Message Rural Hunter 2011-09-11 01:17:13 Re: Backup Question for Point-in-Time Recovery