Обсуждение: Measurement of databases & indexes

Поиск
Список
Период
Сортировка

Measurement of databases & indexes

От
Tourtounis Sotiris
Дата:
I wonder if there is a more formal way of computing the databases' and
the indexes' size than measure them as common data files to the called
base directory of where the Postgres is being installed. Is there any
relative function which calculates a db's data size and all the
constructed indexes in it. I am reallly looking for any comment !!!!



                                                 SWTHRHS TOYRTOYNHS
                                                (tourtoun@csd.uch.gr)



Re: Measurement of databases & indexes

От
Bruce Momjian
Дата:
Yes.  I wrote some new docs for 7.3 at:

    http://developer.postgresql.org/docs/postgres/diskusage.html

---------------------------------------------------------------------------

Tourtounis Sotiris wrote:
> I wonder if there is a more formal way of computing the databases' and
> the indexes' size than measure them as common data files to the called
> base directory of where the Postgres is being installed. Is there any
> relative function which calculates a db's data size and all the
> constructed indexes in it. I am reallly looking for any comment !!!!
>
>
>
>                                                  SWTHRHS TOYRTOYNHS
>                                                 (tourtoun@csd.uch.gr)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073