[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: Database size 1T but unclear why
From:       Justin Pryzby <pryzby () telsasoft ! com>
Date:       2018-12-11 18:55:31
Message-ID: 20181211185531.GN21379 () telsasoft ! com
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]