Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b6tTG-0006Nx-GR for pgsql-hackers@arkaria.postgresql.org; Sun, 29 May 2016 05:41:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b6tTF-0007ZM-GL for pgsql-hackers@arkaria.postgresql.org; Sun, 29 May 2016 05:41:05 +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_2) (envelope-from ) id 1b6tTE-0007ZF-R9 for pgsql-hackers@postgresql.org; Sun, 29 May 2016 05:41:04 +0000 Received: from mail-pa0-x230.google.com ([2607:f8b0:400e:c03::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1b6tT7-00057n-3f for pgsql-hackers@postgresql.org; Sun, 29 May 2016 05:41:04 +0000 Received: by mail-pa0-x230.google.com with SMTP id xk12so51941023pac.0 for ; Sat, 28 May 2016 22:40:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=7oj1wBIGHPD3/XkjRxrznJBe5wmZwv8pXNPCaOChUFc=; b=CvSd84rOcB2zcBt6Z67wpYDVSwYqdjZUceA9imAHbBCMm5AwPzeiYd4VtO1ZAvCr8G yfborAZHAm1Oox7KyHNXJY9XMbkLyd+r4Eb+llEWoOYl8L/l92tU9iztjvCItmUgQcTB XIOYYVOsYRtNeFLxMi46Mxv0P+edXski05m3E= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:content-transfer-encoding :in-reply-to:user-agent; bh=7oj1wBIGHPD3/XkjRxrznJBe5wmZwv8pXNPCaOChUFc=; b=MuKS9qBliGGqZSlehthncWH40uNZoyjK3XTroTAxSRa+aC5pnzIrlp1fZlEjymU2p9 SOI5mpkgLfh5UhrGIde2/ZZ+vnD78PW3sCgFT5szoneEQ0KHDJ294l1/3SQ44NI4KjIE CZ/OrM/g/PRoYkzHjKEf0mYWNypbkEHWTiAB1I4SSSVOL4k+5RsfDDe99dg3Vf3u43IJ hq4aXv/Tfk5Pr5NHLd0yvc+qpwuo8ld2ejlyxJyCJPp6q7IHKL82kt2zzJkWfQdzp8ph 8z2bzjcyT9ZwhU3oYi0arqhq+Q05hAAeZan4UOkXiho5rvcxzIooL32DBKvv9irfQXi6 bvhg== X-Gm-Message-State: ALyK8tKIcwwI3LrjOOWqK6QlZUFQ+SYO3jMfMS7wDXoqeF9vRg8XjT+HuceVTfHheFBeLg== X-Received: by 10.66.117.201 with SMTP id kg9mr35616547pab.27.1464500454908; Sat, 28 May 2016 22:40:54 -0700 (PDT) Received: from tornado.leadboat.com (c-98-248-47-228.hsd1.ca.comcast.net. [98.248.47.228]) by smtp.gmail.com with ESMTPSA id bm8sm8350939pad.10.2016.05.28.22.40.54 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 28 May 2016 22:40:54 -0700 (PDT) Date: Sun, 29 May 2016 01:40:52 -0400 From: Noah Misch To: robertmhaas@gmail.com Cc: =?utf-8?B?0JLQsNGB0LjQu9GM0LXQsiDQlNC80LjRgtGA0LjQuQ==?= , pgsql-hackers@postgresql.org Subject: Re: Performance degradation in commit ac1d794 Message-ID: <20160529054052.GA497229@tornado.leadboat.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) X-Pg-Spam-Score: -2.7 (--) 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 Fri, Dec 25, 2015 at 08:08:15PM +0300, Васильев Дмитрий wrote: > I suddenly found commit ac1d794 gives up to 3 times performance degradation. > > I tried to run pgbench -s 1000 -j 48 -c 48 -S -M prepared on 70 CPU-core > machine: > commit ac1d794 gives me 363,474 tps > and previous commit a05dc4d gives me 956,146 > and master( 3d0c50f ) with revert ac1d794 gives me 969,265 [This is a generic notification.] The above-described topic is currently a PostgreSQL 9.6 open item. Robert, since you committed the patch believed to have created it, you own this open item. If some other commit is more relevant or if this does not belong as a 9.6 open item, please let us know. Otherwise, please observe the policy on open item ownership[1] and send a status update within 72 hours of this message. Include a date for your subsequent status update. Testers may discover new open items at any time, and I want to plan to get them all fixed well in advance of shipping 9.6rc1. Consequently, I will appreciate your efforts toward speedy resolution. Thanks. [1] http://www.postgresql.org/message-id/20160527025039.GA447393@tornado.leadboat.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers