From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | ashkildighin76(at)gmail(dot)com |
Subject: | BUG #17190: lock contention high in postgreSQL13.3 wrt GCC/llvm |
Date: | 2021-09-13 05:32:51 |
Message-ID: | 17190-0efc34364b607e0d@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17190
Logged by: ashkil dighin
Email address: ashkildighin76(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2021-09-13 09:24:46 | Re: BUG #17189: Index not created when primary key created |
Previous Message | PG Bug reporting form | 2021-09-13 05:27:00 | BUG #17189: Index not created when primary key created |