Postgres Pro
Downloads
Home   >   mailing lists

pg_database_size differs from df -s - Mailing list pgsql-general

From Frank Lanitz
Subject pg_database_size differs from df -s
Date
Msg-id 4FCF6A51.9090104@frank.uvena.de
Whole thread Raw
Responses Re: pg_database_size differs from df -s  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_database_size differs from df -s  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Tree view 
Hi folks,

I've got an issue I'm not sure I might have a misunderstanding. When
calling

select sum(pg_database_size(datid)) as total_size from pg_stat_database

the result is much bigger than running a df -s over the postgres folder
- Its about factor 5 to 10 depending on database.

My understanding was, pg_database_size is the database size on disc. Am
I misunderstanding the docu here?

Cheers,
Frank

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: I'd like to learn a bit more about how indexes work
Next
From: Alban Hertroys
Date:
Subject: Re: problem after upgrade db missing