Thread: Re: Updating to PostgreSQL 17.5

Hi Tom,

> On 11 May 2025, at 21:36, Tom Lane <tgl@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