pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rob Audenaerde <Rob.Audenaerde@Valuecare.nl>
Cc: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: database size much bigger than tablespaces on filesystem
Date: Wed, 14 Sep 2011 11:47:14 -0400
Message-ID: <904.1316015234@sss.pgh.pa.us> (raw)
In-Reply-To: <1D020918205F334CBDD5CE7DF2038A2E15A581245A@IE2RD2XVS271.red002.local>
References: <1D020918205F334CBDD5CE7DF2038A2E15A5812457@IE2RD2XVS271.red002.local>
	<1316001615.2110.13.camel@localhost.localdomain>
	<1D020918205F334CBDD5CE7DF2038A2E15A581245A@IE2RD2XVS271.red002.local>

Rob Audenaerde <Rob.Audenaerde@Valuecare.nl> writes:
>>> I check te database size like this:
>>> select pg_size_pretty(pg_database_size('database'))
>>> 595 GB

>> You should also check the space held in $PGDATA/base.

> I did. It is only 320 MB.

Bizarre.  Try breaking the results down table-by-table to see if you can
find where the discrepancy is.

			regards, tom lane

view thread (7+ messages)  latest in thread

Message-ID: <904.1316015234@sss.pgh.pa.us>
Permalink:  ../904.1316015234@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/904.1316015234@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, Rob.Audenaerde@Valuecare.nl, guillaume@lelarge.info
  Subject: Re: database size much bigger than tablespaces on filesystem
  In-Reply-To: <904.1316015234@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox