Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTpfX-0006ct-8R for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Jun 2018 14:25:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fTpfV-0000v2-Qy for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Jun 2018 14:25:37 +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.89) (envelope-from ) id 1fTpfV-0000uk-JE for pgsql-hackers@lists.postgresql.org; Fri, 15 Jun 2018 14:25:37 +0000 Received: from mail-yb0-x229.google.com ([2607:f8b0:4002:c09::229]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fTpfO-0008T4-Rg for pgsql-hackers@lists.postgresql.org; Fri, 15 Jun 2018 14:25:37 +0000 Received: by mail-yb0-x229.google.com with SMTP id x36-v6so3571979ybi.0 for ; Fri, 15 Jun 2018 07:25:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=toe1tLAHPlFYlKQNPg5WqksS/5yae4E4fXM7b4NdECU=; b=ejhIHCK5MZKNYvWnY530E6aE/UP06/2usex507nCbcnd8y0AfjnSSitwdOYCceUtJ9 IpnKd/al/mn+JwyKpkdQtyzVvgjSofK6/nJjitzk/ehNXyg7DghjzdE2psqiLQlVoMJF EWkVLe0QrfOhpZW5Bt0ULoRFhfHKFaSlIKYWDSoxjfy+AssA82aPjo18NJlEqvrf1uwG llF/kIf4Imjp7oUKp4wLoi700Q3tjncu3PDHajlquTUjzhSTwSZgu2LgIKc0+DUU2Cki IbufKFbAP6APWHZEI4QbEK20ZgNS6t3rFvkz8lqAfjOnahttRgJHg9eGJGq+rXyBORft p1mA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=toe1tLAHPlFYlKQNPg5WqksS/5yae4E4fXM7b4NdECU=; b=KF8gMUd/t7EnPcUIB7eQx008HGoQyV4NHYrjIzo/0ER+sIA0CFh9nygmdFQvcuzYh7 m1W9SRsDq64RE49M8KZQxyzWnwD+EpFeM55N1kh12UvhGaym6jEvgDjNlDsoQ4nA6u5T XHXAF5lbprrdNJoevs9Vv1gVloHYlxNEN6TQszj/b5Jp2Xaz4c1+s5K/VV//UeFQVjBx ogIAoP3q1BiDWOrQa422riDseC4IYdxY9XKCx1/fZS4JYmF/Hg1d2l7+Dhd8QQF55xwU BbZAJda4mponf8jq9DDmggN52DxHtsvdOs919yZ35PWOVRfh/CVpCkqxjn5uR6ePvk88 GLHQ== X-Gm-Message-State: APt69E12+CQDw6aRxhYhcAW7Va6EECyVEslNQy89kUHzRD7E/u8TZLOW 0ToaeSypc3XCq0CJXzugaRWg/uTYhTSrR9cgXDV/LNkvl3vdXMj4p0gTpGR7K9yn9dIILyXiwW+ TH+f0sDf8WFd2NX8Xpu5VhUJeclJKb8Lkr1J3nP7dDWe0ofrGKm6CvcO5HTWy0UmElFGrxoSa14 4kL/i1NKxIy8MHi5bO56FL X-Google-Smtp-Source: ADUXVKKMTCx25y+lNAuL0q+ZfDDy+JbUVQr+IoGx4Vrf5HrpERCT9VyixUeouPjyr/YnmuP/rXUsNA== X-Received: by 2002:a25:81c6:: with SMTP id n6-v6mr958359ybm.322.1529072728821; Fri, 15 Jun 2018 07:25:28 -0700 (PDT) Received: from [192.168.10.146] ([98.122.175.38]) by smtp.gmail.com with ESMTPSA id o206-v6sm3139921ywb.30.2018.06.15.07.25.27 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 15 Jun 2018 07:25:27 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: why partition pruning doesn't work? To: Tom Lane Cc: David Rowley , Amit Langote , Dmitry Dolgov <9erthalion6@gmail.com>, Jeff Janes , Ashutosh Bapat , Pavel Stehule , PostgreSQL Hackers References: <22805.1528386192@sss.pgh.pa.us> <21787.1528428171@sss.pgh.pa.us> <6366.1528571895@sss.pgh.pa.us> <12624.1528578026@sss.pgh.pa.us> <26279.1528670981@sss.pgh.pa.us> <17850.1528755844@sss.pgh.pa.us> <23131.1529071325@sss.pgh.pa.us> Message-ID: <5d746bd9-8a79-93c8-885e-f005f7bd06df@2ndQuadrant.com> Date: Fri, 15 Jun 2018 10:25:27 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: <23131.1529071325@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 06/15/2018 10:02 AM, Tom Lane wrote: > Andrew Dunstan writes: >> OK, lousyjack is back online with this, new and improved. It currently >> takes 7.5 hours for a run.  Should I also add -DCATCACHE_FORCE_RELEASE? > I did some experimentation yesterday with valgrind plus both > RELCACHE_FORCE_RELEASE and CATCACHE_FORCE_RELEASE. I didn't find > any new bugs, but adding CATCACHE_FORCE_RELEASE makes things quite > a lot slower :-(. Not sure it's worth it. > > OK. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services