Re: Establishing a local connection to PostgreSQL 9.6 takes seconds

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