Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ti2vA-00AUtl-Ri for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Feb 2025 02:56:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ti2u9-0033ob-Oy for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Feb 2025 02:55:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ti2u9-0033oS-FB for pgsql-hackers@lists.postgresql.org; Wed, 12 Feb 2025 02:55:14 +0000 Received: from mail-il1-x12a.google.com ([2607:f8b0:4864:20::12a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ti2u7-000Mnf-18 for pgsql-hackers@lists.postgresql.org; Wed, 12 Feb 2025 02:55:13 +0000 Received: by mail-il1-x12a.google.com with SMTP id e9e14a558f8ab-3cfc79a8a95so20447635ab.2 for ; Tue, 11 Feb 2025 18:55:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739328909; x=1739933709; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=TMp4ILffCmMv8mWqhQvFpV4K59Kicyx5R9CBsJXyjAA=; b=Zb/12oU4qKX5PSiFjDR0IvP1z02vLT1WSk6NP6Mz3x0yddcFRm5T04Ex5sFidUemAl VaOT0PNZQAsdgKZ3XD85lhGP4yHKLCg6yzTEwUksanQndOAR9i1UdvIIEC9uCGBs/cUv tu7ubHuZuQpK/PQtQt07w7K11WY/i2lahT3ZRRK7SJfwm0nGSHjU7ZlioLQ29auAraKL k8hlrjP/06WcJF4cJ5LymxQR3+YzpH48gY/lsbuqftDR8I2IqPn7SitcQ/QORwJ3bgiY TT2hdjhtir/qG1CdoTe9ScbIEJ2F2KiVZpKsteXv+TJa21QPu2g/d+2YRcYh+yrJn4uU u0Mw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739328909; x=1739933709; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=TMp4ILffCmMv8mWqhQvFpV4K59Kicyx5R9CBsJXyjAA=; b=qbmNaGDnFIsUZ6AnaG6+PKdJagODxrhbNRK0aiRYNDWDEOpIcKEgbxKkJN2qOJl/bP JB+32hCNHkhTvfUBhPkgmOHYWaObm07iSJZLaBDohUDl3FWjC2cMFFOEXJ68/vk3h4X7 JATEZocY2i4mKzkWJzGNlZvOaUHRyIZJu3hZqwpV2Cmyhg8Pft1ijKlZqIlkJL6I9GYQ fUW/61LX9Ms8dKZOab5yAnEGNao4l4HAldhCP4O1KxV5jyiPbx4ELM2eZJ55YWQogKUl p/XUZSPrOHRhqdJbMYhhr2m3093vACjNnheTxbU4uez02eTK427J+BdZDrsKEP1KL7C7 8W8g== X-Forwarded-Encrypted: i=1; AJvYcCXI+X/C2MoUij7Uv48gczGzj+3fo3rrlMVz/CJVGf9v2fpznHzeWrTGeN9RWfOVOTzcpSxP4/kbLHYF2bj7@lists.postgresql.org X-Gm-Message-State: AOJu0Yye9GdtwX0OT5hwvGauNJF79BRIUFsdJeDW4mLf3uTHk6gTcgwi /qR3FyyGxb27ecGnwzCuzPP5ouBuhm9zMyI9j4OzRKtro0N+T/sDAxXPpsRRTqL7UddY128divd GsS3Mk10jp+yErjqnQHFQSGLZuJ0= X-Gm-Gg: ASbGncttM5A9N5VkQLSXoAjMDe4UnM+dh1fVvJ0QiIKe8VTgN8vyvW7Nftvpk0RfQMs fF8ZLLzCs6O0/alOHauJiXusnGT8qvoIxbO/w7NYj7PAvcH8fpJsihI2S8NT/Hx/RQZuZJiYSM2 hHk8BmQarvC5JZYhdmrxI1SGNZ58i6Cng= X-Google-Smtp-Source: AGHT+IF5jmDYDghg0PWKyRZUzQ4+xp8H1QSuw5qMp+CXQ+PW86nCMZy3iVE8gzLVV2sw2uCOnThXvL5I5d4AiFPOfSQ= X-Received: by 2002:a92:cd8c:0:b0:3d0:618c:1b25 with SMTP id e9e14a558f8ab-3d17be1da9amr15626825ab.6.1739328909589; Tue, 11 Feb 2025 18:55:09 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Greg Sabino Mullane Date: Tue, 11 Feb 2025 21:54:33 -0500 X-Gm-Features: AWEUYZnK9uEzIZgpVQNrIJ7V6ys8UeHGekD-3yrbX0JxYH7FHgEMmzZ_CrFh1Ow Message-ID: Subject: Re: [PATCH] Optionally record Plan IDs to track plan changes for a query To: Michael Paquier Cc: Sami Imseih , Lukas Fittl , PostgreSQL Hackers , Marko M , Alvaro Herrera , Julien Rouhaud Content-Type: multipart/alternative; boundary="000000000000cdc674062de91177" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cdc674062de91177 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Feb 11, 2025 at 7:08=E2=80=AFPM Michael Paquier wrote: > On Mon, Feb 10, 2025 at 02:02:10PM -0600, Sami Imseih wrote: > > I am OK with moving away from "jumble" in-lieu of something else, but m= y > thoughts are we should actually call this process "fingerprint" > I agree fingerprint is the right final word. But "jumble" conveys the *process* better than "fingerprinting". I view it as jumbling produces an object that can be fingerprinted. > For node attributes we can specify "fingerprint_ignore" or > "no_fingerprint". What do you think? > Still should be jumble_ignore. Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support --000000000000cdc674062de91177 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Feb 11, 2025 at 7:08=E2=80=AFPM M= ichael Paquier <michael@paquier.x= yz> wrote:
On Mon, Feb 10, 2025 at 02:0= 2:10PM -0600, Sami Imseih wrote:
> I am OK with moving away from "jumble" in-lieu of something = else, but my thoughts are we should actually call this process "finger= print"

I agree fingerprint is the right final wor= d. But "jumble" conveys the *process* better than "fingerpri= nting". I view it as jumbling produces an object that can be fingerpri= nted.

> For node attributes we can specify "fingerprint_ignore" or = "no_fingerprint". What do you think?

Still should be jumble_ignore.

Cheers,
Greg


--
Enterprise Postgres Software Products & Tech Suppo= rt

--000000000000cdc674062de91177--