Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xMAmq-00000001tSA-0c3C for pgsql-docs@arkaria.postgresql.org; Wed, 28 Oct 2026 21:02:20 +0000 Received: from localhost ([127.0.0.1]:48446 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xMAmp-00000000eDe-2h6s for pgsql-docs@arkaria.postgresql.org; Wed, 28 Oct 2026 21:02:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:42738) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xMAmp-00000000eDW-1RgQ for pgsql-docs@lists.postgresql.org; Wed, 28 Oct 2026 21:02:19 +0000 Received: from mail-wm1-x32f.google.com ([2a00:1450:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xMAmn-00000001Q8b-304X for pgsql-docs@lists.postgresql.org; Wed, 28 Oct 2026 21:02:18 +0000 Received: by mail-wm1-x32f.google.com with SMTP id 5b1f17b1804b1-49d05d51553so10955175e9.2 for ; Wed, 28 Oct 2026 14:02:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1793221336; x=1793826136; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to:content-type; bh=MXAWLDc7gsg87dM9e8re2fc0l3T98N35xFvu0jOMSbU=; b=e8mUyCwovyPuGlpJ2Xx3BmOfE9z3fVv9vb+XM9ZJaG68jtC22Z/Bcs7Z9+Z0tr0sGx EyrBaPDe24+ywaXsG0/t6nopOPbQ1haf3KMXHZgAU5IXixslNwWDBWwCthPOrHAhqpJX YOUIORgnqm7Om6nNcDBFSwzSWEDxdc65xFKpOjRSQM/1tp6y5jwbtVcUsWJUNbcrZ87f 6I4fQb9uyNEs9hjpMsYGHbEvoM0hobuNtzvpS2PFKwf53F8hL0hbSDd+u1aHM0Bf0nSs yupU6Jo0dWLmng4dAXxlt7S1yX/qOG+AohPkhBYcPG3rsOb/0/kCjxDyohho8D6TsMZE F06A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1793221336; x=1793826136; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=MXAWLDc7gsg87dM9e8re2fc0l3T98N35xFvu0jOMSbU=; b=LevhPog2DkKtBKt9DGkHjE0+NFPNWLEOoPrBX2bhK4H7FUj0A1fngaT3DFZ7RwLZxG +H6v+cyIWYuhy4U008I2W1t8Xpkj1aRRQ3Kcrp4nTIKHDbIk+h91CvLYrAv2FaRn8QYG 0pWMAHhHCiRnkameaXw5eQN+zypdGMycZ9+P4L2JYkAQ5Z8E02JYvopAjaCU/K+MfJUD 8ASuZjTQa2A5TpSdPfrlqjwbDllBgQ1IsTi2zjJOYlbqsh1uoR62saK7l2XynBxUSXM+ hsxH3i8WjrisaC9HnHgWJG2UmNNYa3Q5wiSbCP4Ax5YSbhOD2rI5wxCjDO8IXvsQOI56 eq5A== X-Gm-Message-State: AFq9FYIZ6Yf5OT5BUbpYGMAIldO4fIsD4ktFbJtaawSvY9ACorLaD2Ys Zp9ADyQkzy0OZCthB8JGi16s2aANi24Lct2NboVmP89FD6P0I7kMNmvz+8E49PaQIR8= X-Gm-Gg: AYBFou2W/c2FpLWG5CGrPsbw444CGsdGEttV9a7tLsrYRlScESpzGUA/xcnxUCs19ff NbcunjFyLNVJmXNWhbFIJBljnaDZOWrYi7hWL5HuGnnQ+eXhzwVgA9NTJL875ly8Z+sbP2ujmyr BrLjdZzzHhragwB4rACyjtZmJAT+ynngF8N5PXk1aj2KSNxz5mChHEAWfqxf6SuHsOcQOX1S7N/ Si0sCW2Kr1Xp2T3gr0NsrAAMROxLwXt6VZ/KpYgNHrVtkpKxtMtWk2Nmdq/cQ85gZ0tN8gCAYld W9j5G684Zwvzc0DSgShcX7g1T5gNdHPFvZtr4mtVC6oDMKOmfexSmpNdG1qGzkkUD+LNf3PWuur yGn42qHj55sbvjvb8QgK89+epHGBs5YfyTo5KMhHHsKleW0pQ03S6mQiX5/uDtbCQ9p1e+gs73x yYuMx1jZvNk0FJm+mtiWI5DTITAR9/Mb5CJQ5u3SUXnAzAmtHQ6aY9temJy/Oisn5GdXF1Bc+Bf QRiNtwQaVpf31Y7ZzZ1alMxjPEAm88Ei7lkD1NnIXbAF0q6yltk2i6snHuX5Vq29padOPpqXVcJ 7KE2Z3QisC5LwsqzfSQbZ1BMkuVAz9Eas6HnykGqj59Q5owTHXsffwVsqotSFRA= X-Received: by 2002:a05:600c:5309:b0:4a2:526b:d3fd with SMTP id 5b1f17b1804b1-4a966a54f16mr78691145e9.15.1793221336098; Wed, 28 Oct 2026 14:02:16 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:b677:677f:591c:a18a:2956]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4aa7fdb75e0sm17466755e9.10.2026.10.28.14.02.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 28 Oct 2026 14:02:15 -0700 (PDT) Message-ID: Subject: Re: OS system version upgrade (glibc / libicu version change) From: Laurenz Albe To: Alexey Shishkin Cc: pgsql-docs@lists.postgresql.org Date: Wed, 28 Oct 2026 22:02:14 +0100 In-Reply-To: References: <177002326159.803.1983703962002247846@wrigleys.postgresql.org> <225d52b51ed9a911ced2f8e6c00e089a1ce50f19.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2026-10-28 at 14:32 +0100, Alexey Shishkin wrote: > On the other hand it should not be only for PG20, but rather for all prev= ious PG versions too. Yes, perhaps. > About the structure: > - first, we should refer to Locale Providers chapter > - then mention that icu/libc locale providers are backed by libicu/glibc = libraries which > versions might change from time to time (even within the lifecycle of t= he same major version of OS) > - libicu/glibc version changes might lead to changes of SQL-queries which= use affected indexes, so > it's important to keep an eye on such changes Simpler said, an index can become corrupted, leading to bad query results and in due course to violated unique constraints. > - the next item should describe what to do in case of=C2=A0libicu/glibc v= ersion changes - mainly about > rebuilding=C2=A0the indexes, but not only > - finally, we should=C2=A0provide the list of commands to identify=C2=A0a= ffected indexes, to rebuild them > online/offline, concurrently etc. There are several strategies to deal with the problem: - rebuild all indexes (simple, slow) - identify all indexes that involve strings (a bit more complicated, faster= ) - check all indexes with amcheck and rebuild only those with a problem (leaves a window where users couls get bad query results - perform a test upgrade and find the affected indexes ahead of time Yours, Laurenz Albe