Hi Mikhail.
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.
Are you using the official Docker Postgres image, specifically `postgres:15.3-bullseye`? ( https://hub.docker.com/_/postgres )
- 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` )
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
Regards,
Imre
