pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Estimate physical index size
3+ messages / 2 participants
[nested] [flat]

* Estimate physical index size
@ 2011-09-10 16:57  Alejandro <ahmostovoi@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Alejandro @ 2011-09-10 16:57 UTC (permalink / raw)
  To: pgsql-admin

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

     Could someone tell me where/what read?

Thanks in advance

Alejandro.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Estimate physical index size
@ 2011-09-11 15:47  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 1 reply; 3+ messages in thread

From: Kevin Grittner @ 2011-09-11 15:47 UTC (permalink / raw)
  To: ahmostovoi@gmail.com; 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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Estimate physical index size
@ 2011-09-11 18:57  Alejandro <ahmostovoi@gmail.com>
  parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 0 replies; 3+ messages in thread

From: Alejandro @ 2011-09-11 18:57 UTC (permalink / raw)
  To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: 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
>
>



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2011-09-11 18:57 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-09-10 16:57 Estimate physical index size Alejandro <ahmostovoi@gmail.com>
2011-09-11 15:47 Re: Estimate physical index size Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-09-11 18:57 ` Alejandro <ahmostovoi@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox