Postgresql version: 15.3 (Debian 15.3-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit And just in case it matters, this is an experimental setup, so Postgresql running in Docker.
- If so, consider upgrading to version 15.4. It has some planner fixes not directly related to your issue. Check details here: PostgreSQL 15.4 Release Notes https://www.postgresql.org/docs/release/15.4/ - For all technical text type id columns apply the `Collate "C"` . ( like `assign_time_str` and `cti_entity_uuid`)
Alternatively, use the "uuid" column type everywhere, as Tom Lane suggests.
- Could you provide details on your current tuning settings? I'm interested in `work_mem`, `shared_buffers`, `effective_cache_size`, and others. - Please test with different `work_mem` values.
If it's not too much trouble, can you also test with: ( These version uses a different locale and LLVM (JIT). ) - postgres:15.4-bookworm - postgres:15.4-alpine3.18