Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZmdJe-0003GE-4u for pgsql-general@arkaria.postgresql.org; Thu, 15 Oct 2015 07:51:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZmdJd-0004OQ-0A for pgsql-general@arkaria.postgresql.org; Thu, 15 Oct 2015 07:51:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZmdHN-0001pn-GE for pgsql-general@postgresql.org; Thu, 15 Oct 2015 07:48:49 +0000 Received: from mail1.openerp.com ([46.105.124.125]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZmdHF-0000mI-GY for pgsql-general@postgresql.org; Thu, 15 Oct 2015 07:48:48 +0000 Received: by mail1.openerp.com (Postfix, from userid 10002) id 7E5C4BF406; Thu, 15 Oct 2015 09:48:39 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on mail1.openerp.com X-Spam-Level: X-Spam-Status: No, score=-1.0 required=5.0 tests=ALL_TRUSTED,T_DKIM_INVALID autolearn=unavailable autolearn_force=no version=3.4.0 Received: from [10.10.23.17] (host-109-88-225-177.dynamic.voo.be [109.88.225.177]) (Authenticated sender: odo@mail1.openerp.com) by mail1.openerp.com (Postfix) with ESMTPSA id ED6CABF406; Thu, 15 Oct 2015 09:48:38 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=odoo.com; s=mail; t=1444895319; bh=200/RqcKgg7R3KjBeUp5H/XxdB5FgKz8WTOPqSSZ7pg=; h=Subject:To:References:Cc:From:Date:In-Reply-To:From; b=Jkqndi/pWhaPctgChNlmHr/OPYrVMueRJBWxTUPLxCn7dMTDwahOcrRe/5r8/tcM7 qBeHyoIyZFgurSQrZbm8Y0A3VxPm5o0Nst35KW/lMrHtF3O4HnNbDPN41hDm4U/RWl eBKpOSZr3OUWpTGqpj+eUCyzX4Vn/q0ZJe0xtdiw= Subject: Re: Serialization errors despite KEY SHARE/NO KEY UPDATE To: Jim Nasby , Kevin Grittner References: <560ED745.3050009@BlueTreble.com> <1354271993.744124.1444079872314.JavaMail.yahoo@mail.yahoo.com> <5614026C.10404@odoo.com> <561BBCD0.1060301@BlueTreble.com> Cc: "pgsql-general@postgresql.org" From: Olivier Dony Message-ID: <561F5A56.2000304@odoo.com> Date: Thu, 15 Oct 2015 09:48:38 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: <561BBCD0.1060301@BlueTreble.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On 10/12/2015 03:59 PM, Jim Nasby wrote: > On 10/6/15 12:18 PM, Olivier Dony wrote: >> >> We would happily skip the micro-transactions (as a perf workaround) if >> there was a way to detect this situation, but we couldn't find a way to >> do that in 9.3. <9.3 we used SELECT FOR UPDATE NOWAIT to guard similar >> cases. >> >> If there is any way I could help to make the back-patch happen, please >> let me know! > > I'd say you should probably open a bug about this to make sure it's > visible if you want it fixed. Or start a thread on -hackers. Good point, I've submitted bug #13681, thanks! :-) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general