public inbox for [email protected]  

help / color / mirror / Atom feed

Re: Updating to PostgreSQL 17.5
2+ messages / 2 participants
[nested] [flat]

* Re: Updating to PostgreSQL 17.5
@ 2025-05-11 19:36  Tom Lane <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Tom Lane @ 2025-05-11 19:36 UTC (permalink / raw)
  To: Paul Foerster <[email protected]>; +Cc: Pgsql-General List <[email protected]>

Paul Foerster <[email protected]> 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 indexes that use one of the "xxx_bloom_ops" opclasses.

https://www.postgresql.org/docs/current/brin.html#BRIN-BUILTIN-OPCLASSES

			regards, tom lane






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Updating to PostgreSQL 17.5
@ 2025-05-11 20:08  Paul Foerster <[email protected]>
  parent: Tom Lane <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Paul Foerster @ 2025-05-11 20:08 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: Pgsql-General List <[email protected]>

Hi Tom,

> On 11 May 2025, at 21:36, Tom Lane <[email protected]> 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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2025-05-11 20:08 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-11 19:36 Re: Updating to PostgreSQL 17.5 Tom Lane <[email protected]>
2025-05-11 20:08 ` Paul Foerster <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox