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 1fTpFC-0004qN-E9 for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Jun 2018 13:58:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fTpFA-00004y-Vf for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Jun 2018 13:58:24 +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 1fTpFA-0008WU-KR for pgsql-hackers@lists.postgresql.org; Fri, 15 Jun 2018 13:58:24 +0000 Received: from mail-yb0-x244.google.com ([2607:f8b0:4002:c09::244]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fTpF7-0007l1-1Q for pgsql-hackers@lists.postgresql.org; Fri, 15 Jun 2018 13:58:24 +0000 Received: by mail-yb0-x244.google.com with SMTP id m137-v6so3530172ybm.6 for ; Fri, 15 Jun 2018 06:58:20 -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=EvFe2GS0s1TvNU3b9zNl3w7IVi9IIw8bJSeVAuzhR9E=; b=CEeYS2GBFAaPZ1tJqL2ZApiKAtzGwVLfNUiDg7nfBivXirqQzRQyc+ndcxWJDtrLne O53DpW/2jwucW/DqsAJmOkVgMoqnSb9iKIvVw/h7uR3qcABsfuPkwseRatnHjmQ8nSZA frNRx72HzzOX9+5TAMn2e8HqO+7c2+Z6ywz+ukD/yJFyq+xqdQPtFlUgKqGH+HjuU+0M ZwAxBDfAMPSIlWAfRU2X6VCSIHeskTDUWOp04wmuRpniuwhfel02n8XQMnuUVHcV6qil 45ilY3H2r9l6A1kOk4f2N2tNI6EEb+SxGek2ME4AH8tCfLGOgpEUtUdqbHLkdAsHW2rj y7BA== 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=EvFe2GS0s1TvNU3b9zNl3w7IVi9IIw8bJSeVAuzhR9E=; b=KHsYRxxh7F/BLTOOMUc6TgW3LtZ9iQhjCmXDNnLqyGtvNSne2L8QHN8iDAMP3uTE0y dIs0OcZOY7dWmRn12EZIkaCjOtVtB2n09Yo1IOq0RWqW4SWSWO61pDSt7AMT0La02gWp N9RZ58ZncjbW9Fdw+iaCwL8Gk0y7sjrMxxWJnniQc+mcFt+lPHDIUrzYLwnbrpXD3rdj 1Knfm73PCyoU0FynsI0J6oMAgRia5nLVYN1J0yO52z71QiJxgGwZhqMS2XJT/0PsbrxK 6hElan0cab29n1Ji6A2as3PlxR7JDmUHy7RpEvPIDvk/kSWAc4fc+DonbGTKzRIOG02q ZKEA== X-Gm-Message-State: APt69E1epWbBfSicY9YZmFku0hfIdhygr5JcpR6HiZfssHaWg/X0ZN+0 BrwZL9otV4Uh3rg/O6GETLQctu6C8ckVxXUY5S2XcoNEAGCykJP6rMV/wvDlyUdmdpVUT/ZR4HM Z+QBT2RARq+HQomK1pGh6aV3vUXHx/BFxhcJfbzsONGKD8dHPc/GTamb57KKq1vTUmaQdZs+ta1 3GpO26y20QENfW1crSoRPG X-Google-Smtp-Source: ADUXVKL4oSexLJwryV6PAsJwn/zJ5kmEZ+6YnAmWUhBEY0526DHvDsq1jA1mgwO6U29ezVxJvJDy9w== X-Received: by 2002:a25:3d01:: with SMTP id k1-v6mr889316yba.217.1529071097775; Fri, 15 Jun 2018 06:58:17 -0700 (PDT) Received: from [192.168.10.146] ([98.122.175.38]) by smtp.gmail.com with ESMTPSA id p3-v6sm2998817ywh.36.2018.06.15.06.58.16 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 15 Jun 2018 06:58:16 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: why partition pruning doesn't work? To: Tom Lane , David Rowley Cc: Amit Langote , Dmitry Dolgov <9erthalion6@gmail.com>, Jeff Janes , Ashutosh Bapat , Pavel Stehule , PostgreSQL Hackers References: <569483c5-a273-6537-1b5d-7a271ce439fb@lab.ntt.co.jp> <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> Message-ID: Date: Fri, 15 Jun 2018 09:58:16 -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: 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/12/2018 07:47 AM, Andrew Dunstan wrote: > > > On 06/11/2018 06:41 PM, Andrew Dunstan wrote: >> >> >> On 06/11/2018 06:24 PM, Tom Lane wrote: >>> >>> If we had any buildfarm critters running valgrind on >>> RELCACHE_FORCE_RELEASE or CLOBBER_CACHE_ALWAYS builds, they'd have >>> detected use of uninitialized memory here ... but I don't think we have >>> any.  (The combination of valgrind and CCA would probably be too >>> slow to >>> be practical :-(, though maybe somebody with a fast machine could do >>> the other thing.) >>> >>> >> >> >> I don't have a fast machine, but I do have a slow machine already >> running valgrind and not doing much else :-) Let's see how lousyjack >> does with -DRELCACHE_FORCE_RELEASE >> >> > > > It added about 20% to the run time. That's tolerable, so I'll leave it > on. > > 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? cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services