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.94.2) (envelope-from ) id 1twbHV-00FtmZ-0W for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 06:27:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1twbHT-00ECsh-IR for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 06:27:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1twbHT-00ECs0-6r for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 06:27:27 +0000 Received: from mail-wr1-x436.google.com ([2a00:1450:4864:20::436]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1twbHQ-000oV0-2n for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 06:27:26 +0000 Received: by mail-wr1-x436.google.com with SMTP id ffacd0b85a97d-399676b7c41so2013589f8f.3 for ; Sun, 23 Mar 2025 23:27:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1742797644; x=1743402444; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=nNwY2NVGnAsWOzmeGg7tCp0CUNVFblncLlwJ1Zxo2RU=; b=r1VTIXUxf1LP+nWo9fiajt8wfvT+T6ZxHZbDGcnjOaQmssU9CpKlKa1f0WGJkUPG+b 7pB1MKJjav0O1CGOFC4F9g303O1RWZKoKCfhfaHYBAmnzYdgjNxrZuZc2f/DGryK5003 maFAsQRlrFeOz+w4lgoZprcwmfBm1OAzW0+jv7GULldSrnqwjWVavC5jRvdZS/5VZKA3 5Fpp7LeI0w/BtrEeAuXGhltFmLDWXEE4r6PoGBPIvmHmcYVw5/6rRfxEgWM0hyx7cHnp HaRf15tehJcMj08+gBMvep6J1K6HNaCgrWEfzKLFTOaJIduGA4tcMLiz7oAGv3sNmG/X ljKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742797644; x=1743402444; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=nNwY2NVGnAsWOzmeGg7tCp0CUNVFblncLlwJ1Zxo2RU=; b=pmjlAMxbHhylDKDozpunHvpdtG8APB04PSJR+uXKqpUJSDK/XQBy78dgjN5kVgetLu 13Be978M+cPmBWjSKYXjLG79nGOexPmOjb7zhmdReAmXX2TVa7BtuK2gR5vRhIc5ui5d d9qC3rTdY3ErqxVoMhp1BhxX225aaNin/JwPauy19ZlICT8HsBqAuY6ASqQGTrud80cn 7Q9s21Ot60O/OCNABkZd0812I0TUD76AasBpZ61lZtq4iseLe+bTYGQvrDZ5kKVUgTld B4fjyTuX5vimClUNJbhIAyZSd7TJVE8rkhFI1UBWra+jGUWcLzAscb+IMjY2brNk26e/ Ov0A== X-Gm-Message-State: AOJu0Yw3ykfikETl0lxpINQE+gKoNAvZcIEHs16uE9+YxVHdeogDRz78 z8h8Gm2zi2DUlJ0m9jswapm6073ZBH3XVrA79sgryITH+mCDC00pYPJ7Lzinjo4TjsJa41OvckI r X-Gm-Gg: ASbGnctm1Tref9L0ptAThgjvnQ3FQ+crVtD+7potJ17KvhRy7KrEv45kz/eNuPwveJq zk9buHw0l4fhK5j/etEWDT1o0bPjfzSNhKTpmSA54lj8B1lSiNfOupSg5p6iZmF+TKrhhcAio2W Okh/rqEQ1/ODkZ7UGEwwaadlP6AU2GZ8tMPukaT8GL6lftnD5set3bRWoRa/sF8WrR5KXanDF45 BRcPr+Sx1fPF9fr88MSCGBA1r+DP4+vYSyqs9xYCQn7eVMNZraTqbVO+6Z4h811TNqF/PPhnchs TxnItUFSRyfsoj6DpXYRvjLHG5f9FJOzyg/G X-Google-Smtp-Source: AGHT+IHNblmqPxXoPB/oy3ai0ajAASU9eV/Xud9MZjXUe17IA+MjcMS6i1pMslOBEibgMTAJNFpeeg== X-Received: by 2002:a5d:64e4:0:b0:38f:3b9b:6f91 with SMTP id ffacd0b85a97d-3997f8fa8f5mr10163359f8f.12.1742797643562; Sun, 23 Mar 2025 23:27:23 -0700 (PDT) Received: from localhost.localdomain ([213.208.157.32]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-43d4fcea6ecsm110672575e9.5.2025.03.23.23.27.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 23 Mar 2025 23:27:23 -0700 (PDT) Message-ID: Subject: Re: COLLATION update in 13.1 From: Laurenz Albe To: Matthias Apitz Cc: pgsql-general@lists.postgresql.org Date: Mon, 24 Mar 2025 07:27:21 +0100 In-Reply-To: References: <20250224023225.197cac12@ardentperf.com> <6118973a513658c4a46d9399f3691d0ef21672e8.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-03-24 at 06:57 +0100, Matthias Apitz wrote: > El d=C3=ADa lunes, febrero 24, 2025 a las 12:41:05p. m. +0100, Laurenz Al= be escribi=C3=B3: > > Perhaps I need not say that, but ALTER COLLATION ... REFRESH VERSION on= ly > > makes the warning disappear. > >=20 > > If you want to avoid data corruption, rebuild all indexes on strings, > > then make the warning disappear. >=20 > One last question related to ALTER COLLATION ... In our clusters are also > the databases 'postgres', 'template0' and 'template1'. The latter we > never us and we CREATE new databases from 'template0'. Anyway, does it > make sense to ALTER COLLATION in these databases as well? I would say so, yes. At least on the template you are using for new databa= ses. By the way, your signature makes Google move your e-mail to "spam". Just s= aying. Yours, Laurenz Albe