On Tue, 2021-10-12 at 13:05 +0530, Ashkil Dighin wrote: > Perf data for 24vu(TPC-C) > -------------------------------- > > 18.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 > > 1.Is there a way to tune the lock contention ? How many concurrent sesions are you running? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
