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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
