Forum OpenACS Q&A: Re: PG relpages vs actual diskspace

Collapse
3: Re: PG relpages vs actual diskspace (response to 1)
Posted by Jonathan Ellis on 02/26/03 10:31 PM
du reports in K (1024 bytes) by default; a pg page is 8 * 1024 bytes by default.  [hence my magic number.]  so that's not a factor.

pg_class includes indexes on separate rows from the base tables, but the global sum will include them as well.

Collapse
4: Re: PG relpages vs actual diskspace (response to 3)
Posted by Jeff Davis on 02/26/03 10:48 PM
the numbers will be correct if you vacuum first since relplages is updated when vacuuming. here is an example: 
# select relpages , relname, relfilenode from pg_class where relfilenode = 1005440;
 relpages |      relname      | relfilenode 
----------+-------------------+-------------
       34 | apm_package_files |     1005440

34 * 8 * 1024 = 278528

$ wc -c ./base/1004872/1005440
 327680 ./base/1004872/1005440

# vacuum analyze  apm_package_files;
VACUUM
xarg=# select relpages , relname, relfilenode from pg_class where relfilenode = 1005440;
 relpages |      relname      | relfilenode 
----------+-------------------+-------------
       40 | apm_package_files |     1005440
40*8*1024 = 327680.