Re: pg_database_size differs from df -s

From: Frank Lanitz <frank(at)frank(dot)uvena(dot)de>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_database_size differs from df -s
Date: 2012-06-06 19:45:41
Message-ID: 20120606214541.1721e9919873a0f17d1c5189@frank.uvena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:
>
> > the result is much bigger than running a df -s over the postgres
> > folder
> > - Its about factor 5 to 10 depending on database.
>
>
> Is your du reporting sizes in Bytes or blocks or ...?

Should be byte as its a linux.

cheers,
Frank
--
Frank Lanitz <frank(at)frank(dot)uvena(dot)de>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2012-06-06 20:17:29 Re: Renumber table rows
Previous Message Viktor Rosenfeld 2012-06-06 19:40:25 Query runtime dependent on ANALYZE run