Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaWkA-0002Gd-6f for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2014 20:47:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WaWk9-0001Kl-Jm for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2014 20:47:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaWk7-0001If-Cw for pgsql-hackers@postgresql.org; Wed, 16 Apr 2014 20:47:39 +0000 Received: from moutng.kundenserver.de ([212.227.126.130]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaWk4-0003mr-BP for pgsql-hackers@postgresql.org; Wed, 16 Apr 2014 20:47:39 +0000 Received: from [10.1.0.2] (190.84.broadband17.iol.cz [109.80.84.190]) by mrelayeu.kundenserver.de (node=mreue005) with ESMTP (Nemesis) id 0M8M5O-1WvmzJ1Jha-00vy1f; Wed, 16 Apr 2014 22:47:32 +0200 Message-ID: <534EEC61.7000006@2ndquadrant.com> Date: Wed, 16 Apr 2014 22:47:29 +0200 From: Petr Jelinek User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.4.0 MIME-Version: 1.0 To: Robert Haas , Andres Freund CC: Tom Lane , Antonin Houska , "pgsql-hackers@postgresql.org" Subject: Re: bgworker crashed or not? References: <20140416131052.GG17874@awork2.anarazel.de> <20140416152803.GJ17874@awork2.anarazel.de> <20140416154412.GL17874@awork2.anarazel.de> <27214.1397663665@sss.pgh.pa.us> <20140416160047.GM17874@awork2.anarazel.de> <20140416161143.GN17874@awork2.anarazel.de> <20140416162837.GO17874@awork2.anarazel.de> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:9OUtJqdf9+vZ6adkMucNwB+dQ3K6Xt5zTpSBHl+COnm SnxaXq2aDE5fPDJOLLKc4RvidUgyjuhfv9139IEcq/hnwP6AKN LHJpOcCRRLzqdNuKIlqldIyOJtn713fDMEKs0gEq0fhUfRG5cH 5E69VQZrDo9TpHWZ9bmXnXuWdI0/yRic7S4GhyORfdBFNeGbaa WrF/JPVRrEoz5ChW1HRIJP2CYQd5y2NRFVrxqYqWVsHJ/2g7/i TO4S7uxYxjP1nzUXMA1HZ453Gt/1qrENAWFS07f80Kf1zUKlXk x8TAVkHLPmpDcS7SlaYpc31UmRALJKQ+Kjl67AfCF4a0Yh7Onu Y5SMu4KASw49ZLTD/K5AJ5Vy9YKq/Wh778YXneHO3 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 16/04/14 18:34, Robert Haas wrote: > On Wed, Apr 16, 2014 at 12:28 PM, Andres Freund wrote: >> On 2014-04-16 12:20:01 -0400, Robert Haas wrote: >>> On Wed, Apr 16, 2014 at 12:11 PM, Andres Freund wrote: >>> I'm still not seeing the problem. It's the background worker's job to >>> make sure that the right stuff gets logged, just as it would be for >>> any other backend. Trying to bolt some portion of the responsibility >>> for that onto the postmaster is 100% wrong. >> >> Well, it already has taken on that responsibility, it's not my idea to >> add it. I merely want to control more precisely what happens.s > > I think that's doubling down on an already-questionable design principle. > > Or if I may be permitted a more colloquial idiom: > > Luke, it's a trap. > Well the logging is just too spammy in general when it comes to dynamic bgworkers but that's easy to fix in the future, no need to make decisions for 9.4. However I really don't like that I have to exit with exit code 1, which is normally used as failure, if I want to shutdown my dynamic bgworker once it has finished the work. And this behavior is something we can set properly only once... -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers