Postgres Pro
Downloads
Home   >   mailing lists

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

From Alejandro
Subject Re: Estimate physical index size
Date
Msg-id 4E6D0484.2000201@gmail.com
Whole thread Raw
In response to Re: Estimate physical index size  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
Kevin,
     thanks for reply.

     I need to estimate the entire database size (tables, indexes,
etc.), prior to create it. I know how to calculate a table size, but I
don't know how to calculate an index size.

Thanks.


Alejandro


On 11/09/11 12:47, Kevin Grittner wrote:
> 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: "Kevin Grittner"
Date:
Subject: Re: MSAccess migration to Postgres through ODBC
Next
From: "Marc Mamin"
Date:
Subject: how can I get "initial_value"(setting_name) ?