Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1huddt-0005H8-Jp for pgsql-hackers@arkaria.postgresql.org; Mon, 05 Aug 2019 14:07:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hudds-00028i-GZ for pgsql-hackers@arkaria.postgresql.org; Mon, 05 Aug 2019 14:07:16 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hudds-00028Q-3K for pgsql-hackers@lists.postgresql.org; Mon, 05 Aug 2019 14:07:16 +0000 Received: from mail-qt1-x841.google.com ([2607:f8b0:4864:20::841]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1huddp-0006Od-4j for pgsql-hackers@lists.postgresql.org; Mon, 05 Aug 2019 14:07:15 +0000 Received: by mail-qt1-x841.google.com with SMTP id l9so80960792qtu.6 for ; Mon, 05 Aug 2019 07:07:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=fOpnlHADQFtOCjKGlwVyPJL25przd0apYaiIsWXl92Y=; b=da90EbOolYumrFK4xbrjE+tMm5PEZbWi/od2/84cq/H2lw5A/XlZouK+4Yo/Ph4IrP E6ODU009B7wTqmv8PDaMGsCgb/cH4NDbFWzrKD1S/RcDUj0hEBkc8tJ8bwEIPhopUNEj ywxncgR+3l0aKMLMsjs0aDH/cEKMmoLrbsEksFi/gy4PMDARFkPspLPKwkmraPnSe0OU XW1V53yJqPlbN9wtMyMdBu5c1rnr6ugzRZu1KJEuS7g4vtuZ7cQJtRonVfKXhCYMiO4d GZdBACvXusD/QSc8wuvkW+t5VlGQc6R+Bv7+iLOXV45A7ZgLzbfDMmNXXuXUFIZRpU0P 7mYQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=fOpnlHADQFtOCjKGlwVyPJL25przd0apYaiIsWXl92Y=; b=bYujRIQI266grs/MtblsoxCjekVo76qFWUY8kjzAmludpUZfNXTHjfEANEqItiXFo+ TxeT2psjFT/w6e4x6NaNFQV5JYbe33S3JhLtCY/AmZdWfEEni+10krIHvtk2o4uQKqIR 4uRlXN2PThWYycisFGk/3rExR5yL/qQtczr3fCWclHYVyt8iz3gtQfmZF85dQtxC1Kut yPPnGtZGv3ZLJYKpM7UkQ9KattMTNsGu2J6B5T1tqaH0KJC7ACH99emqNSspyFmQx0Nm r/ZlEVmHAQvh2AvCzq0om2GrBvHpTE5JUBF98jz+OLOSwPQBOdHvL7wP6lhQ4Wd5dXz6 Gj0w== X-Gm-Message-State: APjAAAX8GcUuum21YJGoolzH/HnvreOs1+H48zDR5yeXcs5D7xYxVTJ4 eVdfglA4KtbAc2Ze/IhaKP2Z5w== X-Google-Smtp-Source: APXvYqzPQlrbpX6eNIFUAfJM53V0az5CpSRcTJxJVgv2VcX5pm/JhImZiGS1dhekuxmdy9efVsBT2w== X-Received: by 2002:ad4:55a9:: with SMTP id f9mr109663526qvx.133.1565014031597; Mon, 05 Aug 2019 07:07:11 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([201.186.81.5]) by smtp.gmail.com with ESMTPSA id m12sm33331847qkk.123.2019.08.05.07.07.10 (version=TLS1_3 cipher=AEAD-AES256-GCM-SHA384 bits=256/256); Mon, 05 Aug 2019 07:07:11 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 48068120662; Mon, 5 Aug 2019 10:07:06 -0400 (-04) Date: Mon, 5 Aug 2019 10:07:06 -0400 From: Alvaro Herrera To: yuzuko Cc: shawn wang , Shawn Wang , PostgreSQL Hackers Subject: Re: Problem with default partition pruning Message-ID: <20190805140706.GA4512@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Aug-05, yuzuko wrote: > However, I'm still concerned that the block > ----- > ... > ----- > is written in the right place as Amit explained [1]. Yeah, I have that patch installed locally and I'm looking about it. Thanks for the reminder. I also have an eye on Horiguchi's patch elsewhere in the thread. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services