Thread: estimating size of db

estimating size of db

From
Marc Tardif
Date:
Is there any way to estimate the size of a db for x rows, considering each
row uses y bytes (no varchar) and uses index z? Basically, I'm looking for
the order of growth for tables and indices in general, simply to get a
idea of the storage requirements for a particular db.

Marc


Re: [GENERAL] estimating size of db

From
Bruce Momjian
Date:
See FAQ.

> Is there any way to estimate the size of a db for x rows, considering each
> row uses y bytes (no varchar) and uses index z? Basically, I'm looking for
> the order of growth for tables and indices in general, simply to get a
> idea of the storage requirements for a particular db.
>
> Marc
>
>
> ************
>
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026