• Home
• ca.uhn.hapi.fhir
• hapi-fhir-docs
• 7.6.1
• source code
• 5547-postgres-collation-utf8-migration-detect-add-index.yaml

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

ca.uhn.hapi.fhir.changelog.7_0_0.5547-postgres-collation-utf8-migration-detect-add-index.yaml Maven / Gradle / Ivy

---
type: fix
issue: 5547
title: "Previously LIKE queries against resources would perform poorly on PostgreSQL if the database locale/collation was not 'C'.
        This has been resolved by checking hfj_spidx_string.sp_value_normalized and hfj_spidx_uri.sp_uri column
        collations during migration and if either or both are non C, create a new btree varchar_pattern_ops on the
        hash values.  If both column collations are 'C', do not create any new indexes."