From: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
---|---|
To: | Frank Lanitz <frank(at)frank(dot)uvena(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_database_size differs from df -s |
Date: | 2012-06-07 20:02:13 |
Message-ID: | 1339099333.2520.10.camel@asus-1001PX.home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2012-06-07 20:07:54 | Re: Problem while restoring a database from SQL_ASCII to UTF-8 |
Previous Message | Adrian Klaver | 2012-06-07 19:48:29 | Re: Missing row after update |