Re: Establishing a local connection to PostgreSQL 9.6 takes seconds

Thanks for the immediate reply.

It turned out to be pg_attribute. It was bloated probably due to the large
number of temp tables created.
Are there any recommendations on how to prevent such a bloat from happening?

On Wed, Jun 16, 2021 at 4:10 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Marcin Barczynski <mbarczynski(at)starfishstorage(dot)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
>

--

*Marcin Barczyński* | *Senior Software Engineer * |

mbarczynski(at)starfishstorage(dot)com | http://www.starfishstorage.com