locale - Search results in mailing lists

2025-02-28 23:02:59 | Re: Slow performance of collate "en_US.utf8" (Joe Conway)

locale. Something like: -------- CREATE DATABASE builtincoll LOCALE_PROVIDER builtin BUILTIN_LOCALE 'C.UTF-8' TEMPLATE

2024-10-06 20:28:29 | Re: Performance degradation in Index searches with special characters (Andrey Stikheev)

Locale Provider | Collate | Ctype | Locale | ICU Rules

2023-09-11 15:17:33 | Re: Planning time is time-consuming (Imre Samu)

uses a different locale and LLVM (JIT). ) - postgres:15.4-bookworm - postgres:15.4-alpine3.18 Regards, Imre

2021-10-28 02:31:00 | Views don't seem to use indexes? (Tim Slechta)

locale | text | | | | extended | preference | text | | | | extended | status

2021-09-23 13:00:22 | hashjoins, index loops to retrieve pk/ux constrains in pg12 (Arturas Mazeika)

locale. lc_ctype English_United Kingdom.1252 Shows the character classification and case conversion locale. lc_messages

2021-08-22 00:14:53 | RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (ldh@laurent-hasson.com)

Locale: en-us;English (United States) > Input Locale: en-us;English (United States) > Time Zone

2021-05-06 21:16:45 | Re: Very slow Query compared to Oracle / SQL - Server (Imre Samu)

locales other than C or POSIX in PostgreSQL is its performance impact. It slows character

2020-09-16 03:39:08 | Performance issue when we use policies for Row Level Security along with functions (Gopisetty, Ramesh)

locale')) then return '''COMMON_' || SYS_CONTEXT('ctx_ng', 'ctx_prod_locale')||''''; elsif vpd_key = SYS_CONTEXT

2020-09-14 03:18:26 | Re: Performance Issue (Not using Index when joining two tables). (Gopisetty, Ramesh)

locale filters the table where the prod_locale_code is provided initially. Before running any queries

2020-05-18 18:42:09 | Execution time from >1s -> 80m+ when extra columns added in SELECTfor sub-query (A Guy Named Ryan)

locale. lc_ctype | en_US.utf8 | Shows the character classification and case conversion locale. lc_messages

2020-03-30 10:12:33 | Re: Increasing work_mem slows down query, why? (Pavel Stehule)

locales). Then the cost of hash join and sort is similar, although in reality it is not true

2020-03-21 14:26:17 | Re: Slow planning time when public schema included (12 vs. 9.4) (Tom Lane)

locale settings you're using. That's affecting your planning time (since the planner will

2019-05-07 16:14:43 | GCC 8.3.0 vs. 9.0.1 (Steven Winfield)

locale=C - the db is started with "pg_ctl start -o '-c autovacuum=false'" - createdb

2019-04-29 10:36:20 | Generic Plans for Prepared Statement are 158155 times slower thanCustom Plans (Naik, Sameer)

Locale United States Hardware Abstraction Layer Version = "6.1.7601.24354" User Name Not Available Time Zone Central

2019-04-01 10:20:48 | Re: Postgresql Sort cost Poor performance? (Andrew Gierth)

locale other than C. The slowdown for using other locales varies according to the data