| From: | Alexander Kulikov <a-kulikov(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | small database huge planning time |
| Date: | 2026-01-13 09:16:08 |
| Message-ID: | AS4PR02MB874303264FDEF9B160C06DF9EA8EA@AS4PR02MB8743.eurprd02.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello!
I have got huge planning time for a query in quite small database in PortgreSQL 17
Planning Time: 452.796 ms
Execution Time: 0.350 ms
Tried several version from 17.3 to 17.7 (cpu 2.2GHz) - it almost does not matter. If I run query many times in row planning time may reduce down to 430ms but never less.
Tried in PortgreSQL 11 (in a little bit different hardware with cpu 2.60GHz) - planning time almost ten times less.
Changing parameters: from_collapse_limit, join_collapse_limit, geqo, jit, work_mem and many
others does not help at all. I attach 1. additional setting in the
postgresql.status.conf. 2. querry itself in query.sql. 3. zql plan in
query.sqlplan 4. additioanal information about os, tables etc. would you
please help me -Alexander Kulikov
| Attachment | Content-Type | Size |
|---|---|---|
| postgresql.status.conf | text/plain | 2.9 KB |
| query.sql | text/plain | 6.5 KB |
| Potgres Perfomance.txt | text/plain | 23.7 KB |
| query.sqlplan | text/plain | 11.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Lepikhov | 2026-01-13 09:29:45 | Re: small database huge planning time |
| Previous Message | Nikolay Samokhvalov | 2026-01-09 22:29:20 | Re: Troubleshooting a brief spike in active sessions |