diff options
| author | Fujii Masao <fujii@postgresql.org> | 2020-07-03 11:35:22 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2020-07-03 11:37:24 +0900 |
| commit | 8d459762b10372e48845a49b305f4e1e165fe173 (patch) | |
| tree | 8468bf183e1f75656e5c7508c57adb2a40b90000 /src/backend/utils/adt/jsonb_util.c | |
| parent | 83fa48c8cd26c9a8171a85e786bb6ae1c5b04139 (diff) | |
| download | postgresql-8d459762b10372e48845a49b305f4e1e165fe173.tar.gz postgresql-8d459762b10372e48845a49b305f4e1e165fe173.zip | |
Change default of pg_stat_statements.track_planning to off.
Since v13 pg_stat_statements is allowed to track the planning time of
statements when track_planning option is enabled. Its default was on.
But this feature could cause more terrible spinlock contentions in
pg_stat_statements. As a result of this, Robins Tharakan reported that
v13 beta1 showed ~45% performance drop at high DB connection counts
(when compared with v12.3) during fully-cached SELECT-only test using
pgbench.
To avoid this performance regression by the default setting,
this commit changes default of pg_stat_statements.track_planning to off.
Back-patch to v13 where pg_stat_statements.track_planning was introduced.
Reported-by: Robins Tharakan
Author: Fujii Masao
Reviewed-by: Julien Rouhaud
Discussion: https://postgr.es/m/2895b53b033c47ccb22972b589050dd9@EX13D05UWC001.ant.amazon.com
Diffstat (limited to 'src/backend/utils/adt/jsonb_util.c')
0 files changed, 0 insertions, 0 deletions