From: | Jean-Christophe Boggio <postgresql(at)thefreecat(dot)org> |
---|---|
To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: I don't understand that EXPLAIN PLAN timings |
Date: | 2024-01-26 04:22:58 |
Message-ID: | a09afdae-c2c2-48b3-982f-1e44f2bb31cd@thefreecat.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello,
In case it might be useful, I made some more tests.
On my dev computer (a notebook) I installed:
PostgreSQL 15.5 (Ubuntu 15.5-1.pgdg23.10+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 13.2.0-4ubuntu3) 13.2.0, 64-bit
and
PostgreSQL 16.1 (Ubuntu 16.1-1.pgdg23.10+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 13.2.0-4ubuntu3) 13.2.0, 64-bit
I adjusted work_mem to 1GB and disabled JIT, restored the same DB, did
VACUUM ANALYZE and ran the query several times to lower I/O interference.
Execution time is about the same on PG 14, 15 and 16, around ~120ms
I noticed that planning time, whatever the version, is very variable
between executions (ranging from 0.120ms to 0.400ms), probably due to
other programs activity and <1ms measurements imprecision. So the
results I gave you in my previous email are probably irrelevant.
On our production server, which is running PG 14.10 on Debian 11, same
work_mem, execution time is ~45ms but planning time is much more
consistent at ~0.110ms
Interestingly though, lowering work_mem to 32MB gives 22ms execution
time but planning time rises consistently at ~0.7ms
On my notebook with work_mem=32MB, execution time is also 22ms but
planning time is lower at ~0.4ms (?!?)
Let me know if I can do anything to provide you with more useful
benchmark. The DB is still very small so it is easy to do tests.
JC
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2024-01-26 04:46:19 | Re: I don't understand that EXPLAIN PLAN timings |
Previous Message | Jean-Christophe Boggio | 2024-01-26 03:22:53 | Re: I don't understand that EXPLAIN PLAN timings |