Le mercredi 06 juin 2012 à 21:45 +0200, Frank Lanitz a écrit :
> On Wed, 6 Jun 2012 20:31:36 +0200
> Alban Hertroys <haram...@gmail.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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to