Re: Printing backtrace of postgres processes
Christoph Berg <myon@debian.org>
From: Christoph Berg <myon@debian.org>
To: Michael Paquier <michael@paquier.xyz>
Cc: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, vignesh C <vignesh21@gmail.com>, torikoshia <torikoshia@oss.nttdata.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-02-26T15:05:05Z
Lists: pgsql-hackers
Re: Michael Paquier > Something like this can be measured with a bunch of concurrent > connections attempting connections and a very high rate, like pgbench > with an empty script and -C, for local connections. I tried that now. Mind that I'm not a benchmarking expert, and there's been quite some jitter in the results, but I think there's a clear trend. Current head without and with the v28 patchset. Command line: pgbench -n -C -c 20 -j 20 -f empty.sql -T 30 --progress=2 empty.sql just contains a ";" model name: 13th Gen Intel(R) Core(TM) i7-13700H head: tps = 2211.289863 (including reconnection times) tps = 2113.907588 (including reconnection times) tps = 2200.406877 (including reconnection times) average: 2175 v28: tps = 1873.472459 (including reconnection times) tps = 2068.094383 (including reconnection times) tps = 2196.890897 (including reconnection times) average: 2046 2046 / 2175 = 0.941 Even if we regard the 1873 as an outlier, I've seen many vanilla runs with 22xx tps, and not a single v28 run with 22xx tps. Other numbers I collected suggested a cost of at least 3% for the feature. Christoph
Commits
-
Perform apply of large transactions by parallel workers.
- 216a784829c2 16.0 cited
-
Enhance pg_log_backend_memory_contexts() for auxiliary processes.
- 790fbda90209 15.0 cited
-
Allow GRANT on pg_log_backend_memory_contexts().
- f0b051e322d5 15.0 cited
-
Move Perl test modules to a better namespace
- b3b4d8e68ae8 15.0 cited
-
Unify PostgresNode's new() and get_new_node() methods
- 201a76183e20 15.0 cited
-
Add backtrace support for error reporting
- 71a8a4f6e365 13.0 cited