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.96) (envelope-from ) id 1w2FER-0007TS-1G for pgsql-committers@arkaria.postgresql.org; Mon, 16 Mar 2026 21:12:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2FEP-00D10S-0p for pgsql-committers@arkaria.postgresql.org; Mon, 16 Mar 2026 21:12:09 +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.96) (envelope-from ) id 1w2FEP-00D10K-08 for pgsql-committers@lists.postgresql.org; Mon, 16 Mar 2026 21:12:09 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2FEM-00000000UTb-2sWg for pgsql-committers@lists.postgresql.org; Mon, 16 Mar 2026 21:12:08 +0000 Received: by mail-wr1-x42b.google.com with SMTP id ffacd0b85a97d-439c9bdc1eeso5027164f8f.3 for ; Mon, 16 Mar 2026 14:12:07 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773695526; cv=none; d=google.com; s=arc-20240605; b=H2ZRVkhF+T6u+DRey4kz7FV2vveB7V55h5yjn/o9rtYKwbjGIUY5uD4JoRuuiC7Kow TrjRuj+12W1hz5U8k+phi8vvBH+lAoog08/5k42nKGHbvdJ2WXGOB2476YCw0iEDchep gfocV5CTGwKwkeqRqQHFeMG/YWEv1T+k3UNrtsQcyj3efyarLGwxD/hR/X2lqvtrdfEH uy+M2g0SNOq6dPz+XFxbzxA64HI04cmERhYYf9L60sRd0r8tIyglqsIgwYFOisSrh0ZC +dSlB0XcUPZ6evwHNec6EKvcnaTmhbjRyRTpb8gNdo9bwmPOhJBwWBFFpIUwfkPdxEtg jDSQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=F2FxBgTA1WXrcyr+6SO5TUWUOBmbYMut9ybabMi5yXU=; fh=WptU2a29pD52+TpI9XLdVWl6b1V+Hm3UVTJP14mV3Hg=; b=R0hTickfZ8J7WlS4RuvGrZ8ZsPV0vTchfNUQuxl1ZwAuo8a0YWbnnqkzneOwW3Ba4R YSHCrUmcoOzWa3szvz2zIXWbx7rCprlgNNguGHWbaPa11ucfH/6yEmWLYW37xoUpHy07 RtdiUtvb78g3Gk6U7IkzpFbf1/z9K3Wq4qJU1hNmnursp3Fsk8+bs5bdgkkFrKnHhvAn /qmQuHhnyp+nRDw2Nw0nHUXhCicYtHSdlrSTsveqQlrcHjzDts2eA8+m5bCAvEhVUpkV Tpm9ksyemuMl3/cnrqVMRDO+gcHtACxf47RBvJHxipYDmckuPI+81LxBjdFlRrxLjX03 xflA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773695526; x=1774300326; 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=F2FxBgTA1WXrcyr+6SO5TUWUOBmbYMut9ybabMi5yXU=; b=a3rqHf+L8VqeGE8iJVxBkUMZJWkz8HDJzOCL59Seo/NtYqWe1+LjrGvkKOg4+/rlGR 3xW/8nX9648mV2Vips2F8lEqG2c8igBo7r1ztRXOomfKsnZ4pcAx/Cu5+kVfTl6gaqwv Eyar34Em8SSYzMYPPOeFJbfLgmGWy0X0fAWbPUu0u4jwwblCTKlr35Z0aSBJ3P28wrH1 M/xLdvyQyeVCksT8uGt2PS8uedHgi5IBB2GXTeJ7v+1nfSLzOpbaKlboI14x/19G7S4M f3aiKk6At5L/lykY1bGm5nka2z02qP9PzvmS4wYu9PjqMWqeW/vevqgK+UHN4gn0mPil c4FA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773695526; x=1774300326; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=F2FxBgTA1WXrcyr+6SO5TUWUOBmbYMut9ybabMi5yXU=; b=hgFL/5MHQ4rIO8Yf+lhkT7/q+VoJbdxrbUewfJ3GxOYDYR2fomsGMKCjhePfDMWS6F Fdm5vW8Mz9/9RzyRgV9xiLi8e+OOB6XKJjRDLpGYZaeYnKR0CtG0Ucr50pfxjcsygri0 XBYIzxJxOsu7Zqzx8cV+rmWWwKliqUgwJ3vmFGK8gAXu/o1aj14CAfcs6B615tNu1BeN um4wmzhfhoydmL7yPgSM0jP3Ru6EBkOrtF2i2trbeloZY1XNZ3CQiDv27fguVworIwk9 reHnkHTQ2mBxJj4YgDAbbnNptaAdnarJyIZAc9gZT80i8la+uthv/z62mZgByDhJrNPa 3BQA== X-Gm-Message-State: AOJu0YxXm794h1FTGnR6WAgoPB7X0/Gbj9a3Ue+Q2YLvinKT3Dt6bJIB qxtAil1iI6Ezdc3fYJdADNkM+/I2GLkmJ/N3bMrN28Dv/MGEpva8aHp2qWbDxbSJJrF9V/SekQI iq7JylSGo6bghO7DzuIVsZDRLhyexTrY= X-Gm-Gg: ATEYQzyH4Ud1zAtn5/TZdTBGc9cc2yLN1MhJsJzyLHfXI1PunqiQs7em+orBozBVKpP RwuLe2fIoluYw7pV65ghcCEIMg+Spod7j9cdxqlX5RqXB04Lx3aocvSL9fyqLGqD3WMmAFD2Y+W qRuwxpynB38pZRfQeNDoWNCuu1i0nwkEUe+BA+rGBQ2AKHhylEmHhQAzeiLWspWd9EKSzuiEt08 ZXDY5rGwfVw2sjlLGxO0+6HZrPQLHabUUmq6PuPjFcgqp/U9yD/j2jatJNdCCVTdRZURScNJFii pj+R3dg18CLBXzcNzCTvk3xG8SFxObKxNCw6jRE4aWXBLh6J1i97Zywg0TFTP8q4KEOud8ZL X-Received: by 2002:a5d:64c3:0:b0:439:d755:a895 with SMTP id ffacd0b85a97d-43a04dc06bcmr26654818f8f.42.1773695526121; Mon, 16 Mar 2026 14:12:06 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: David Rowley Date: Tue, 17 Mar 2026 10:11:54 +1300 X-Gm-Features: AaiRm52KQUAEGGMMmoLxIfm9Fe1h_11e2T2TQAPHnSiIsLIypCmx4hJZ8wDXem4 Message-ID: Subject: Re: pgsql: Add pg_plan_advice contrib module. To: Robert Haas Cc: pgsql-committers@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 On Fri, 13 Mar 2026 at 06:01, Robert Haas wrote: > Add pg_plan_advice contrib module. Hi Robert, I was just building with VS2026 when I noticed the following warning: ../contrib/pg_plan_advice/pgpa_planner.c(1195): warning C4319: '~': zero extending 'uint32' to 'uint64' of greater size I guess the compiler is concerned that you might not have meant to unconditionally switch off all the upper 32-bits of the 64-bit variable. Adding the following does get rid of the warning for me, but not sure if that's what you had intended. I've not studied the code enough to understand why there are two different integer widths being used for the bits. - *pgs_mask_p &= ~(PGS_JOIN_ANY & ~join_mask); + *pgs_mask_p &= (uint32) ~(PGS_JOIN_ANY & ~join_mask); David