Re: measuring disk usage of records

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matthew Nuzum" <cobalt(at)bearfruit(dot)org>
Cc: "'P(dot)J(dot) \"Josh\" Rovero'" <rovero(at)sonalysts(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: measuring disk usage of records
Date: 2004-01-01 17:38:17
Message-ID: 21652.1072978697@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Matthew Nuzum" <cobalt(at)bearfruit(dot)org> writes:
> Thanks for the very quick reply... I didn't know about the dbsize stuff,
> they may help. Unfortunately, the records are mixed together.

When measuring the on-disk size of a table, don't forget to include its
indexes and its toast table (and the toast table's index).

If you are using large objects, you'll also need to think sbout charging
for the space occupied by pg_largeobject.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Casey Allen Shobe 2004-01-01 17:43:44 Re: Is my MySQL Gaining ?
Previous Message Tino Wildenhain 2004-01-01 16:33:25 Re: Is my MySQL Gaining ?