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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux