Re: Database size 1T but unclear why - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: Database size 1T but unclear why
Date
Msg-id 20181211185531.GN21379@telsasoft.com
Whole thread Raw
In response to Re: Database size 1T but unclear why  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
On Sun, Dec 09, 2018 at 10:01:08AM -0600, Justin Pryzby wrote:
> On Sun, Dec 09, 2018 at 05:18:55PM +0200, Mariel Cherkassky wrote:
> > I'm trying to understand why my database consume so much space. I checked
> > the space it consume on disk :

To find single relations which are using more than 100GB,
you could also run:
|find ..../base/17312 -name '*.[0-9]??'

(technically that should be a regex and not a shell glob but seems to work well
enough).

Justin


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: database crash during pgbench run
Next
From: Mariel Cherkassky
Date:
Subject: pgbench results arent accurate