Le mercredi 06 juin 2012 à 21:45 +0200, Frank Lanitz a écrit : > On Wed, 6 Jun 2012 20:31:36 +0200 > Alban Hertroys <haramrae@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
