Querying an index's btree version

From: Darren Lafreniere <dlafreniere(at)onezero(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Querying an index's btree version
Date: 2020-03-11 20:25:51
Message-ID: CABoC1=46ULyzvqZnu6AAH621mguVV2doavWQEsfr3thbtPPpAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We've read that PG 12 has improved btree index support, and that the latest
internal btree version was bumped from 3 to 4. Is it possible to query the
btree version that a particular index is using? We'd like to automatically
start a concurrent re-index if we detect any btree indexes are still on
version 3.

Thank you,
Darren Lafreniere

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2020-03-11 20:30:38 Re: Querying an index's btree version
Previous Message Stephen Frost 2020-03-11 19:24:14 Re: Web users as database users?