Re: Planning time is time-consuming

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` )
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