Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-13360

Detect which indexes need to be rebuilt for collations

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Normal Normal
    • Schema change, 2024 Q2
    • None
    • Back-end
    • None

      In the Postgres database the indexes have to be rebuilt whenever a new version of libc/icu is deployed in the system. It would be more handy to detect when this is actually needed.

      It can be implemented by querying the column "collversion" of the table "pg_collation" available in Postgres 12 already.

            bitmap Michael Wiencek
            yvanzo yvanzo
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Version Package
                Schema change, 2024 Q2