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 1telO2-00FVG5-ST for pgsql-general@arkaria.postgresql.org; Mon, 03 Feb 2025 01:36:31 +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 1telNz-009IR9-FE for pgsql-general@arkaria.postgresql.org; Mon, 03 Feb 2025 01:36:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1telNz-009IR0-4f for pgsql-general@lists.postgresql.org; Mon, 03 Feb 2025 01:36:27 +0000 Received: from mail-io1-xd42.google.com ([2607:f8b0:4864:20::d42]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1telNw-002rpa-36 for pgsql-general@lists.postgresql.org; Mon, 03 Feb 2025 01:36:26 +0000 Received: by mail-io1-xd42.google.com with SMTP id ca18e2360f4ac-844e394395aso96384839f.3 for ; Sun, 02 Feb 2025 17:36:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738546584; x=1739151384; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=36n5zTtbt0K2+LmXCxrtKLDcuClAUd4r01dvnjQJw8g=; b=RsbnhZbR4QDZKtt6bNv9169Hku29z08u0EmSloX0cFpAkMSENvOK+5IDQE1udKufGx xK8r4oFAy67mydelvaGgTV0Ngc5CzshXpyjQV4hd6QboOoCu+HfSSpplDnN1KScKSqRc 1W7zhK/CxAaWNb88tYHTysFRKKXytGrMnvPpk0HMkEKDwd67L5PaIVq8CmixZPmo/kt6 II2+l4mNN6g72PB+Apt8QJtrCCfwOh/X+VHaghP8UM9UDVENYaOmtHqMLg56Vc6+ga6n zanOoWgkYZu/nhJuP4RNGMnIAJYomSAXCCB+x8d4kJqhEMnuO9rp6SFYztSuDcBBLWTq ezAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738546584; x=1739151384; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=36n5zTtbt0K2+LmXCxrtKLDcuClAUd4r01dvnjQJw8g=; b=jqBhSs/cJCswac+I96r7DXxHYI5SobCKL3LQ/63BCx7ZM024YGsciIbY28bDf9pmSs ZI/+9hJL28StFDinaGUOwlL3aJ6GkltFHP8euMtXAJu8E7m5Zgi2eaR4PpGmermrc7mz j64pb+7mWIwztXU7Qm8qtr+wg6SxpebrcBY7WCRSKFjzbtKIr2Ptbtrj2J4GjQtrGtu5 q/R46RDo5dWTGJ/0WcX6Cr493HGesLlsVDSyBcxduvUi8jr2U3ge9otzl0wjX+a9WQKg RjgXK/2UvTHjQof830dDY4ui4EljUvHWPhiy4eudfk6nBAWTXl+ulvK2XlPziVaxKy0q K1iw== X-Gm-Message-State: AOJu0YxB6IgvOkp+bcYUx6au1GZNkIvkbtCw91f9vGmOsjKk5W5WFLBU KpHAoHwSawiOt2M/EWpmxyesfqphDZUsu/pit3UUJLszWMxoAK5WDMwyfDYw5zAeYbFwRle36Wd BLEep7TAyYFFb+WvfZgg/J3ePd9HrUAsK3c8= X-Gm-Gg: ASbGncuTbNsJ/dVNRuiYoaMUfoAwPgD32pZ6LCjrOm1JIx/EcsdwCOUScieryNe7hkt X6m/WQRa9ldfd+o7uqupE2qjortHUPDBIzhfV67CiB/isMQrK5ZHpdWAzRTt45uOWahaiJgIRfg == X-Google-Smtp-Source: AGHT+IGpr/iC/iPRi5knVddF1Kz+F+rNQtnYPQema9BpD+Ot1vovBcObpdYMaRlecvnPeobl3TGJfgbjYkyUuFYaoyI= X-Received: by 2002:a05:6602:400a:b0:843:e667:f196 with SMTP id ca18e2360f4ac-85427e04ebemr2431364839f.4.1738546584091; Sun, 02 Feb 2025 17:36:24 -0800 (PST) MIME-Version: 1.0 From: Marcelo Fernandes Date: Mon, 3 Feb 2025 14:36:13 +1300 X-Gm-Features: AWEUYZnCGEndsU-jkDZtjLFHaGHFhgTE36Ufq_rr4ApkJMOiEXhnKCrEFxfGR7g Message-ID: Subject: What is the story behind _SPI_PLAN_MAGIC? To: pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi there, Reading through the SPI code I see this definition: #define _SPI_PLAN_MAGIC 569278163 Which is used in he _SPI_plan struct in src/include/executor/spi_priv.h: typedef struct _SPI_plan { int magic; ... } What is its purpose? Thank you. Marcelo