Re: measuring disk usage of records - Mailing list pgsql-general

From Tom Lane
Subject Re: measuring disk usage of records
Date
Msg-id 21652.1072978697@sss.pgh.pa.us
Whole thread Raw
In response to Re: measuring disk usage of records  ("Matthew Nuzum" <cobalt@bearfruit.org>)
List pgsql-general
"Matthew Nuzum" <cobalt@bearfruit.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

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: Is my MySQL Gaining ?
Next
From: Tom Lane
Date:
Subject: Re: speeding up inserts