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 <t...@sss.pgh.pa.us> wrote: > Marcin Barczynski <mbarczyn...@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 > -- *Marcin Barczyński* | *Senior Software Engineer * | mbarczyn...@starfishstorage.com | http://www.starfishstorage.com
