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 1uECyd-004aoW-Gn for pgsql-general@arkaria.postgresql.org; Sun, 11 May 2025 20:08:47 +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 1uECyc-00B2t8-47 for pgsql-general@arkaria.postgresql.org; Sun, 11 May 2025 20:08:46 +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 1uECyb-00B2sw-NL for pgsql-general@lists.postgresql.org; Sun, 11 May 2025 20:08:45 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uECyY-001OgY-29 for pgsql-general@lists.postgresql.org; Sun, 11 May 2025 20:08:45 +0000 Received: by mail-wm1-x334.google.com with SMTP id 5b1f17b1804b1-43d0618746bso28306105e9.2 for ; Sun, 11 May 2025 13:08:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1746994122; x=1747598922; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=zxNYkjpmrVUjPFcmZ/5sBnEDZ8ExxiQb2mQqhuRyejQ=; b=VhML3sSUFQAH9nl0TMCNih/se0YT/TyjYu8pyZPSu6z+7wbW17fk93Hd9t1yijdAKc INpo8/x/HPTQYu84rKzWxeGRe5MCNhJQs/YpnwUcQwtBXaBEX9GqOxKkJUgeGBL8TA6x VQ6YDE8YskgDkc6wsPZIf9Cv8uf+hVLYKkLLbH7DlOlzQywvsLmGK6R+48b/+wq2t8Ej JVXAhSvC5zfBtDVMg2FQEC2mp7G2Vl3ySuNTsLvxi9W1tAGNAzm5My8JwBs3Vc9XxqQ4 hsHunOgqO4W0PrTX2xNciCmagTLQzEoXLXb+vatGA4utVShNf5VHD6/+w7p2ssNEnNlN bi0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746994122; x=1747598922; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=zxNYkjpmrVUjPFcmZ/5sBnEDZ8ExxiQb2mQqhuRyejQ=; b=rRo3W/8PHEkN7G/MR4N53yVPL/9Y3utxX5c3IKP8px4C57lBjZ12NsH/DyIZPZ9zLG XUDTjr1F3buqTAUSIfw0+GyGUN2+Weth+GhjvbyP6jzbKC0o6DG51EqLzlD44DQfqntg 9NkV7z9Q5AVs5UDCQiIu8CwV7TexhjMyTr8cXmxifn5ilwf+UhsjAJzfDbDdQHzebP6T 27Bfbk6GpKEbyGl67Q1fzBhj0LS3ryPlbMqtZ/j6ilkc9taKDAk0DuJGJoRhOHL/Ci5O 4ulONAzvEvO9I6vDRjJPwHC33qZpTA/ACmVGLdxsrGXRcFI5IWoT3Upp9FAi822llyDD kTKg== X-Gm-Message-State: AOJu0YxVAnUjpd62w7pjXIlCdgpJZo3kX81B26utAHJusFozcc33jmNJ 6j3t0Vmn1BU2oG6wp4N0BVYtoDTlLqob4rpbeA/gAjSRJWAXigpF X-Gm-Gg: ASbGncukaYJe7iJjgIjH9DTeLVcAbUuH1lkrjZ4dAPBlsnxO7zEe0T02qD/dUfOtHfR dK7vD3qkCbWTKkaTI5uw/hYmcWM51pKtF9g19hl7YqvRaJB/GAFLZp0R+GObTNEEJ+OYQ1epphE VuXK6mlFPj1Bo6q8L8zEA/7/ocxBoiFghtPdhfmfm+5GTMV8Da8IK2rb2C532R2GSMOXoYK/mT2 K62j5TFy9KDzh0MGeeWTgapzbgcw3jsyL9WqPqzqcGk+ARkdmRw/qxZWcJiIAfaxW8sHgq12P9G ISfvAHylDzhNXh4rlnpdrL6GQXnMxcMenZSXuDhvubZcE57jyszFmupJ0iZkotfjMdkxUk2VwON LNp2BDjUHPnSmA3sMu/mLbVxEDGWf X-Google-Smtp-Source: AGHT+IH0300AaJn1WlR+A0kAqvBwOCdI9/aKpHYxzXxZHw2wClBOHLLw6yJqewTNPwbGjcCUAr8m6A== X-Received: by 2002:a05:600c:1f16:b0:43d:fa5d:9315 with SMTP id 5b1f17b1804b1-442d6ddf507mr75960175e9.33.1746994121313; Sun, 11 May 2025 13:08:41 -0700 (PDT) Received: from smtpclient.apple (143-45-239-77.dyn.cable.qlnet.ch. [77.239.45.143]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-442d67d5c2asm101982065e9.1.2025.05.11.13.08.40 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 11 May 2025 13:08:40 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.500.181.1.5\)) Subject: Re: Updating to PostgreSQL 17.5 From: Paul Foerster In-Reply-To: <1121569.1746992169@sss.pgh.pa.us> Date: Sun, 11 May 2025 22:08:08 +0200 Cc: Pgsql-General List Content-Transfer-Encoding: quoted-printable Message-Id: <158E731D-A29B-4E0D-8E3F-C0061BE7AAFB@gmail.com> References: <492F08D2-73F0-4CB7-85C7-8602304A448F@gmail.com> <1121569.1746992169@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3826.500.181.1.5) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Tom, > On 11 May 2025, at 21:36, Tom Lane wrote: >=20 > Sorry --- it means BRIN indexes that use one of the "xxx_bloom_ops" = opclasses. >=20 > = https://www.postgresql.org/docs/current/brin.html#BRIN-BUILTIN-OPCLASSES Ah, so that'd reduce my monster query to: select concat ('reindex index "', schemaname, '"."', indexname, '";') as = reindex_cmd from pg_indexes where indexdef ~ '_bloom_ops'; Thanks very much. Paul=