Postgres Pro
Downloads
Home   >   mailing lists

Re: Establishing a local connection to PostgreSQL 9.6 takes seconds - Mailing list pgsql-general

From Tom Lane
Subject Re: Establishing a local connection to PostgreSQL 9.6 takes seconds
Date
Msg-id 646103.1623852611@sss.pgh.pa.us
Whole thread Raw
In response to Establishing a local connection to PostgreSQL 9.6 takes seconds  (Marcin Barczynski <mbarczynski@starfishstorage.com>)
Responses Re: Establishing a local connection to PostgreSQL 9.6 takes seconds
List pgsql-general
Tree view 
Marcin Barczynski <mbarczynski@starfishstorage.com> writes:
> It's always /opt/prod/pg/9.6/base/18370/1108887031. Unfortunately, no trace
> of it in pg_class:

It's probably a mapped system catalog, which will have relfilenode = 0.
Try

SELECT relname FROM pg_class WHERE pg_relation_filenode(oid) = 1108887031;

My guess is that whichever catalog it is is badly bloated.

            regards, tom lane

pgsql-general by date:

Previous
From: Marcin Barczynski
Date:
Subject: Establishing a local connection to PostgreSQL 9.6 takes seconds
Next
From: Marcin Barczynski
Date:
Subject: Re: Establishing a local connection to PostgreSQL 9.6 takes seconds