Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TVCK9-0000qn-17 for pgsql-admin@postgresql.org; Mon, 05 Nov 2012 02:22:01 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TVCK4-0005yc-Sp for pgsql-admin@postgresql.org; Mon, 05 Nov 2012 02:22:00 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id qA52LuaJ029488; Sun, 4 Nov 2012 21:21:56 -0500 (EST) From: Tom Lane To: Greg Williamson cc: "pgsql-admin@postgresql.org" Subject: Re: autovacuum with lots of open file references to deleted files In-reply-to: <1352079622.31433.YahooMailNeo@web125901.mail.ne1.yahoo.com> References: <7015.1350260875@sss.pgh.pa.us> <347905F6-B93E-4259-A8A9-28DBAC51D014@pvv.ntnu.no> <27617.1352076455@sss.pgh.pa.us> <1352079622.31433.YahooMailNeo@web125901.mail.ne1.yahoo.com> Comments: In-reply-to Greg Williamson message dated "Sun, 04 Nov 2012 17:40:22 -0800" Date: Sun, 04 Nov 2012 21:21:55 -0500 Message-ID: <29487.1352082115@sss.pgh.pa.us> X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201211/17 X-Sequence-Number: 40262 Greg Williamson writes: >> So far, my guess is that this is fixed by commits a1f064fc2 + d7598aeea. > Is there any idea of when this will be released ? No. I'd guess that there will be update releases before the end of the year, but they are not imminent. We have some open issues that have to be settled first, notably http://archives.postgresql.org/pgsql-hackers/2012-10/msg00511.php regards, tom lane