| From: | Alejandro <ahmostovoi(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Estimate physical index size |
| Date: | 2011-09-11 18:57:08 |
| Message-ID: | 4E6D0484.2000201@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Mamin | 2011-09-12 09:59:37 | how can I get "initial_value"(setting_name) ? |
| Previous Message | Kevin Grittner | 2011-09-11 15:52:28 | Re: MSAccess migration to Postgres through ODBC |