Re: pg_database_size differs from df -s

Le mercredi 06 juin 2012 à 21:45 +0200, Frank Lanitz a écrit :
> On Wed, 6 Jun 2012 20:31:36 +0200
> Alban Hertroys <haramrae(at)gmail(dot)com> wrote:
>
> > On 6 Jun 2012, at 16:33, Frank Lanitz wrote:
> >

> >
> > Is your du reporting sizes in Bytes or blocks or ...?
>
> Should be byte as its a linux.
>

Not sure about this; from du's man page :

Display values are in units of the first available SIZE from
--block-size, and the DU_BLOCK_SIZE, BLOCK_SIZE and BLOCKSIZE
environment variables.
Otherwise, units default to 1024 bytes (or 512 if POSIXLY_CORRECT is
set).

vv=# select sum(pg_database_size(datid)) as total_size from
pg_stat_database;
total_size
------------
105086036
(1 ligne)

du -s base
103808 base

--
Vincent Veyron
http://vincentveyron.com
Logiciels de gestion pour le service juridique