Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m1dBr-0005BZ-B1 for pgsql-performance@arkaria.postgresql.org; Thu, 08 Jul 2021 23:12:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m1dBq-0007Hm-5c for pgsql-performance@arkaria.postgresql.org; Thu, 08 Jul 2021 23:12:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m1dBp-0007He-NY for pgsql-performance@lists.postgresql.org; Thu, 08 Jul 2021 23:12:17 +0000 Received: from aibo.runbox.com ([91.220.196.211]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m1dBm-0002bf-1E for pgsql-performance@postgresql.org; Thu, 08 Jul 2021 23:12:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=runbox.com; s=selector1; h=Content-Transfer-Encoding:Content-Type:MIME-Version: Message-ID:Date:Subject:In-Reply-To:References:Cc:To:From; bh=Tssq+ZYVpNwZqVnrVTn1LnScw/kgzVLRPbP1B6wDPqA=; b=gGCziU26kVKYzyQbYq5zh1TlXT 73BLECthH0QpSPnOD7rAGXRzAOnt+LwYvAr7VdnourMNinsy69cdqlx25s+ySHVepukQphPHDtr44 p/SShPWUr8IsQaufnJSR2hq2XsXNQOQgqXfJTvLhg3DI3Bwbjn0nDc4ThmMOBJa+oYgxabSsAjM4t WFJ2IoQ6iJYJpTzcx9KJHbU4gxUnqCmTGSKxRZPlWO7g/y45ussWpqyT3d5YLfPwHXluqPorBJBKu 88rhj8SbosYqFIQgb2t2AmudL96R5c5CT5ALsKnXjaOCi1sKVXKQ1g91eU0m15P+q5ZJgGYEaHJfG yNyHlGeg==; Received: from [10.9.9.73] (helo=submission02.runbox) by mailtransmit03.runbox with esmtp (Exim 4.86_2) (envelope-from ) id 1m1dBf-0002h2-VP; Fri, 09 Jul 2021 01:12:08 +0200 Received: by submission02.runbox with esmtpsa [Authenticated ID (300526)] (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) id 1m1dBf-00005Y-Jm; Fri, 09 Jul 2021 01:12:07 +0200 From: "Mike Sofen" To: "'Alvaro Herrera'" , "'Justin Pryzby'" Cc: "'Nagaraj Raj'" , References: <20210708221703.GA1301@telsasoft.com> <202107082228.obnak7c7mx4n@alvherre.pgsql> In-Reply-To: <202107082228.obnak7c7mx4n@alvherre.pgsql> Subject: RE: Partition column should be part of PK Date: Thu, 8 Jul 2021 16:12:03 -0700 Message-ID: <080901d7744e$ac0f3d70$042db850$@runbox.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQI0b0d+I/SkBI69wtPwH5SCzfQSy6p/vj+A Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I believe this thread qualifies for the funniest thread of 2021 (so = far). And yes, this is a top post. :-) Mike Sofen -----Original Message----- From: Alvaro Herrera =20 Sent: Thursday, July 08, 2021 3:29 PM To: Justin Pryzby Cc: Nagaraj Raj ; pgsql-performance@postgresql.org Subject: Re: Partition column should be part of PK On 2021-Jul-08, Justin Pryzby wrote: > If I'm not wrong, this is the same thing you asked 2 week ago. >=20 > If so, why not continue the conversation on the same thread, and why=20 > not reference the old thread ? >=20 > I went to the effort to find the old conversation. > https://www.postgresql.org/message-id/20210625042228.GJ29179@telsasoft > .com Actually, it looks like you're replying to the same email you replied to = two weeks ago. --=20 =C3=81lvaro Herrera Valdivia, Chile =E2=80=94 = https://www.EnterpriseDB.com/