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 1to1AT-004sCO-4u for pgsql-performance@arkaria.postgresql.org; Fri, 28 Feb 2025 14:16:46 +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 1to1AU-007L4U-3x for pgsql-performance@arkaria.postgresql.org; Fri, 28 Feb 2025 14:16:44 +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 1to1AT-007L49-Q1 for pgsql-performance@lists.postgresql.org; Fri, 28 Feb 2025 14:16:44 +0000 Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1to1AO-000Bg4-1z for pgsql-performance@lists.postgresql.org; Fri, 28 Feb 2025 14:16:43 +0000 Received: by mail-ej1-x62b.google.com with SMTP id a640c23a62f3a-abf1da0cb66so240858666b.3 for ; Fri, 28 Feb 2025 06:16:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1740752201; x=1741357001; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=bzoa8j9OHfpiZ+PwPLDeU33ul9qZrfiot7sIx3bbrlY=; b=jAHGqRCYu3FJ+FJcUwpG5AGgv7c5tM2Z1TwqsqYnIXmwM10qTG99OKo5zINjiPdlsf wJ8HnPOUx8pp1wg/wumHRJ4MMs0KZaEpuFnEDFkqcCdgRZpWiy24+DA6VsgQ0HgstAuc QpZ+Ld+08TF9aWVEN292K4/ILCSuBCvx17nrmPEeDRR66VlrMXZGBLzsrBqmNqgQUCrV /zMiMTWdfKiJorkJ8purJJVxpC+N221E8xj3xXTeT7N+NedBxTAXDSY4mbBFsPGA78Np KmZ/Q4VwJhf1AwD8QpwI0bs7Q5nnzRF5jsYdd8bjAPYZj6pTDjl9E/mJ6ZeSS+EqzbkD v3YA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740752201; x=1741357001; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=bzoa8j9OHfpiZ+PwPLDeU33ul9qZrfiot7sIx3bbrlY=; b=kEroxr20aD5S58aJuve0HYLVgdH2IJ+CvEZuiz0xMhG96k/J+zgv0XdksoIzV9uKEi Wy9ul2XM63qDYmIBqE5yqU92amsrbsyT8lW9wx6fZ/x+FZ5xTTpGX/+fNNgZfkbnZ6qR kIXcgRBFP9lvnY2TaULKM4zUsvV/zmyKX8yO6gK+N2A892SyQcOGkl87Q9eZsD9CMFG3 oO5UI3IiMw/tG+kca54/YR3RzD405bQJFrmmHSQ7AFhhYgm73saXKXQa6tALpDopRKlZ Wu+owFIahUu1vuJAhi+XeQwcMXcGpiWoVbhHjyezjdY/45i7FHZ4RCVS5d/A2AxQiiqe Qevg== X-Forwarded-Encrypted: i=1; AJvYcCWTb9/fePHyb6JcxS1f8LsgZLWOYjO4LcBB4yrKX1YZMRoN+bpGsw8ZqSY8l4/oFgO15KqJxsXvzLBbUEAeh6VeoA==@lists.postgresql.org X-Gm-Message-State: AOJu0YzmlRs8eC23gCJBL+HOwnJAIAUX09oAYc8MpWcp3VHwZhvvp3ti 27sinNiypEEJg6YW+gKoqj1aiPKuyEn/XLez4bAm+wbTiVs8jlOo82AL1fsAYBBS0dpE+zCeg46 ldMk= X-Gm-Gg: ASbGnct9LGw6SnpObb5gHQLGVaA4enorHVE34K15b6DZCoJqmSnGU0/c1+sswmwkKW9 SqCqvTAwMxUh/cwtLiElTcXkCNc1U7Z9W4JK246kGbVFVoYoo5JBTbnJ9eyhcZa8pmKgpIlTmWk I+GOHTLecnkQKxLXrKv2oXcP8oVljzEuVmmobmewWC8ExF2gIAgdt7vI3VirsUwZLfOqFNWGeG1 qz1w3oQSFhJSSt0320wiMjSMqmIRPdc1/12Etot0K9yUNUM+viimLdpgg3gb1B2ykcWI93GsxwI O/GE+rn7gSTRYuJ1r3KF6umE+FBC4/Sm9/v1N+z64WsJYA== X-Google-Smtp-Source: AGHT+IElSIpjzwgck+IRUJF2DGHW7EGXRYYbuobo6cuiLrqKt9X+FKZZA00R4vDPDoiPLVOLxoRtSA== X-Received: by 2002:a17:906:3097:b0:abf:489b:5c77 with SMTP id a640c23a62f3a-abf489b5ea3mr4383966b.31.1740752200814; Fri, 28 Feb 2025 06:16:40 -0800 (PST) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-abf0c0baadfsm293158866b.23.2025.02.28.06.16.40 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 28 Feb 2025 06:16:40 -0800 (PST) Message-ID: <1ab051d93e215a31b2a7af9b522c918bca9b484f.camel@cybertec.at> Subject: Re: Slow performance of collate "en_US.utf8" From: Laurenz Albe To: Alexey Borschev , pgsql-performance@lists.postgresql.org Date: Fri, 28 Feb 2025 15:16:40 +0100 In-Reply-To: References: 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 Thu, 2025-02-27 at 16:54 +0300, Alexey Borschev wrote: > I see poor performance of text sorting of collate "en_US.utf8" in PG 17.4= . I'd say that you would have to complain to the authors of the GNU C library, which provides this collation. Yours, Laurenz Albe