pg_database_size differs from df -s

Поиск
Список
Период
Сортировка
От Frank Lanitz
Тема pg_database_size differs from df -s
Дата
Msg-id 4FCF6A51.9090104@frank.uvena.de
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: I'd like to learn a bit more about how indexes work
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: problem after upgrade db missing