'autovacuum with lots of open file references to deleted files' back from 2012

From: Evgeniy Losev <e(dot)losev(at)i-dgtl(dot)ru>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: 'autovacuum with lots of open file references to deleted files' back from 2012
Date: 2018-08-16 11:28:11
Message-ID: b84ee3dd61ff45b6935186fb9180927b@srv-exch-mb02.i-free.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello.

We are running PostgreSQL 9.5.13 and we faced the very same issue as described in this thread: https://www.postgresql.org/message-id/B9BEA448-978F-4A14-A088-3FD82214FFAC%40pvv.ntnu.no
Briefly, we have got heavy update/insert/truncate activities on many tables and we're noticed that autovacuum processes hold a lot of file descriptors to deleted data-files (in sum >300GB).

The last answer from Tom Lane in that thread was:
"So far, my guess is that this is fixed by commits a1f064fc2 + d7598aeea."

Is there any patches/configuration recommendations to solve this problem yet?

Thank you.

--
Evgeniy Losev
Senior System Administrator
i-Digital

Browse pgsql-admin by date

  From Date Subject
Next Message Maycon Oleczinski 2018-08-16 13:27:32 pgAdmin 4 v3.1 & v3.2 eternal loading
Previous Message Laurenz Albe 2018-08-16 10:49:38 Re: Cursors