Re: Updating to PostgreSQL 17.5

[Paul Foerster]

Hi Tom,

> On 11 May 2025, at 21:36, Tom Lane <t...@sss.pgh.pa.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