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 1ggZJC-0005IA-55 for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Jan 2019 18:07:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ggZJ9-0006jQ-AC for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Jan 2019 18:07:27 +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 1ggZJ9-0006g0-10 for pgsql-hackers@lists.postgresql.org; Mon, 07 Jan 2019 18:07:27 +0000 Received: from mail-qt1-f196.google.com ([209.85.160.196]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggZJ5-0004qt-Cz for pgsql-hackers@postgresql.org; Mon, 07 Jan 2019 18:07:26 +0000 Received: by mail-qt1-f196.google.com with SMTP id t13so1483002qtn.3 for ; Mon, 07 Jan 2019 10:07:22 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:reply-to:subject:to:references:from:organization :message-id:date:user-agent:mime-version:in-reply-to :content-language:content-transfer-encoding; bh=XoqMHcVou69KM/CiNXgC14Xrp3m2G39qcZZShusr5Kc=; b=NvL+9zzhG/NCvuLlOmT/yuRBHvnAS/Mvx1kaLKSZcGKwadxL/e09Asf/kr8K4h7eJq RgHrGVuNREuvluRfoGNxlO8MkYc+fmWF5+F8r1uT4xmHkxZcUr/YuxVe9Izr9rS/tetd stHU0CetLJPQamglVX4Bhfyzo2ApBj4tftZ11XccxSEAnmlWKXQuTtcsIUSDgaTuQ1EH wcqeIXY55BLdIXtvJweSo3yU2Fq798Y3dU/ejDFcYiG5VAlk5GZ1s0sEsZqiSE4qrXvl rHE5RCHDB7HpZHfskiq7F5u1yKWDpw83RtJaRW7Y4AOH7ZeLhneUP4OMu2DV1rPQDA/S sNCA== X-Gm-Message-State: AJcUukfpKSnGqG8PEqRAfaO5HZuABQ0Kfhj7B3fGNDqZ7rD+D13+MbWE Soci/V/7TNnWC3t73ycfDiYzq0ZllSY= X-Google-Smtp-Source: ALg8bN6+EjXrDaZdO2SAoUQwpZvsOPfe/X8WWHySd94WMX0QI54xqlpa3NtrYe6TIgXf2CgDV7eO+A== X-Received: by 2002:a0c:bd15:: with SMTP id m21mr61523620qvg.57.1546884440493; Mon, 07 Jan 2019 10:07:20 -0800 (PST) Received: from localhost.localdomain (c-24-61-8-151.hsd1.ma.comcast.net. [24.61.8.151]) by smtp.gmail.com with ESMTPSA id g25sm27780871qki.29.2019.01.07.10.07.18 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 07 Jan 2019 10:07:19 -0800 (PST) Reply-To: jesper.pedersen@redhat.com Subject: Re: partitioned tables referenced by FKs To: Alvaro Herrera , Pg Hackers References: <20181130191216.5xcxcsx3ascgqayv@alvherre.pgsql> From: Jesper Pedersen Organization: Red Hat Message-ID: Date: Mon, 7 Jan 2019 13:07:18 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.1 MIME-Version: 1.0 In-Reply-To: <20181130191216.5xcxcsx3ascgqayv@alvherre.pgsql> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 11/30/18 2:12 PM, Alvaro Herrera wrote: > Here's a more credible version of this patch series. > The patch series applies with hunks, and passes check-world. No comments for 0001, 0002, 0003 and 0005. While I'm still looking at 0004 - should we have a test that updates one of the constraints of fk to another partition in pk ? I'll didn't try this yet with [1], so sending you a flamegraph of INSERTs off-list, since data loading takes a while during an OLTP based work load. Thanks for working on this ! [1] https://commitfest.postgresql.org/21/1897/ Best regards, Jesper