BUG #17190: lock contention high in postgreSQL13.3 wrt GCC/llvm
От | PG Bug reporting form |
---|---|
Тема | BUG #17190: lock contention high in postgreSQL13.3 wrt GCC/llvm |
Дата | |
Msg-id | 17190-0efc34364b607e0d@postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 17190 Logged by: ashkil dighin Email address: ashkildighin76@gmail.com PostgreSQL version: 13.3 Operating system: RHEL8.4 Description: Example Perf data for 24vu(TPCC) -------------------------------- 20.99% postgres postgres [.] LWLockAcquire 7.09% postgres postgres [.] _bt_compare 8.66% postgres postgres [.] LWLockRelease 2.28% postgres postgres [.] GetSnapshotData 2.25% postgres postgres [.] hash_search_with_hash_value 2.11% postgres postgres [.] XLogInsertRecord 1.98% postgres postgres [.] PinBuffer Is there way to tune the lock contention ? Is any recommendations to tune/reduce the lock contention via postgres.conf(like buffers). Postgres.conf =========== shared_buffers = 64000MB huge_pages = on temp_buffers = 4000MB work_mem = 4000MB maintenance_work_mem = 512MB autovacuum_work_mem = -1 max_stack_depth = 7MB dynamic_shared_memory_type = posix max_files_per_process = 4000 effective_io_concurrency = 32 wal_level = minimal synchronous_commit = off wal_buffers = 512MB #checkpoint_segments = 256 checkpoint_timeout = 1h checkpoint_completion_target = 1 checkpoint_warning = 0 log_min_messages = error log_min_error_statement = error log_timezone = 'GB' autovacuum = off datestyle = 'iso, dmy' timezone = 'GB' lc_messages = 'en_GB.UTF-8' lc_monetary = 'en_GB.UTF-8' lc_numeric = 'en_GB.UTF-8' lc_time = 'en_GB.UTF-8' default_text_search_config = 'pg_catalog.english' max_locks_per_transaction = 64 max_pred_locks_per_transaction = 64
В списке pgsql-bugs по дате отправления: