Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ayjX8-0007sk-P9 for pgsql-admin@arkaria.postgresql.org; Fri, 06 May 2016 17:27:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ayjX8-0004KH-Bz for pgsql-admin@arkaria.postgresql.org; Fri, 06 May 2016 17:27:22 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ayjVO-0000e8-6a for pgsql-admin@postgresql.org; Fri, 06 May 2016 17:25:34 +0000 Received: from out.smtp-auth.no-ip.com ([8.23.224.60]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1ayjVG-000788-HK for pgsql-admin@postgresql.org; Fri, 06 May 2016 17:25:32 +0000 X-No-IP: alvh.no-ip.org@noip-smtp X-Report-Spam-To: abuse@no-ip.com Received: from alvin.alvh.no-ip.org (unknown [216.155.90.98]) (Authenticated sender: alvh.no-ip.org@noip-smtp) by smtp-auth.no-ip.com (Postfix) with ESMTPA id D8159400D3F; Fri, 6 May 2016 10:25:24 -0700 (PDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id C26DC419; Fri, 6 May 2016 14:25:22 -0300 (CLST) Date: Fri, 6 May 2016 14:25:22 -0300 From: Alvaro Herrera To: Tom Lane Cc: =?utf-8?B?T25kxZllaiBTdsSbdGzDrWs=?= , pgsql-admin@postgresql.org Subject: Re: Autovacuum of pg_database Message-ID: <20160506172522.GA222225@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <5836.1462552696@sss.pgh.pa.us> User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Tom Lane wrote: > Alvaro Herrera writes: > > Tom Lane wrote: > >> Actually, I realized after looking at it that the new wi_tableshared > >> field is unnecessary in my patch. The only important part is that > >> knowledge of relisshared be available when we're looking for conflicting > >> workers, and that is entirely local in do_autovacuum(). I'd started the > >> patch by adding wi_tableshared, on the expectation that it would be > >> necessary, but it ain't ... > > > OK, if I understand you correctly then that is what my patch does -- the > > "sharedrel" flag in my patch is only inside do_autovacuum. Do you > > already have a test rig for this? > > I didn't attempt to replicate the problem report, if that's what you > mean; I just tested it as far as running the regression tests. OK. I'll do some more targeted testing later before pushing. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin