Re: Database size 1T but unclear why

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Database size 1T but unclear why
Date: 2018-12-11 18:55:31
Message-ID: 20181211185531.GN21379@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mariel Cherkassky 2018-12-12 12:53:35 pgbench results arent accurate
Previous Message Tom Lane 2018-12-11 16:01:14 Re: database crash during pgbench run