Re: Updating to PostgreSQL 17.5

Hi Tom,

> On 11 May 2025, at 21:36, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Sorry --- it means BRIN indexes that use one of the "xxx_bloom_ops" opclasses.
>
> 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