Hi Tom,
> On 11 May 2025, at 21:36, Tom Lane 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 "', s
Paul Foerster writes:
> the release notes for PostgreSQL 17.5
> (https://www.postgresql.org/docs/17/release-17-5.html) state:
> "Also, if you have any BRIN bloom indexes, it may be advisable to reindex
> them after updating."
> I don't know what exactly that means.
Sorry --- it means BRIN inde
Hi,
the release notes for PostgreSQL 17.5
(https://www.postgresql.org/docs/17/release-17-5.html) state:
"Also, if you have any BRIN bloom indexes, it may be advisable to reindex them
after updating."
I don't know what exactly that means. So I read about BRIN and BLOOM indexes
and learned how
