Re: PostgreSQL 9.6 Temporary files

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Jimmy Augustine <jimmy(dot)augustine(at)enyx(dot)fr>, Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL 9.6 Temporary files
Date: 2018-03-19 18:32:15
Message-ID: fe2c06a4-ac02-312b-0f1b-b96f2974df14@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 03/19/2018 10:27 AM, Jimmy Augustine wrote:
> I tried this query and my database size is equal to 162GB.
>

Well you can always look in $DATA directly. The database will be under
$DATA/base/<db oid>.

You can find the <db oid> like this:

select oid, datname from pg_database where datname='<db name>';

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Finzel 2018-03-19 19:37:24 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Previous Message Andres Freund 2018-03-19 18:17:23 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid