Re: PostgreSQL 9.6 Temporary files

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.klaver@aklaver.com