Hi,
Yes, lock contention reduced with postgresqlv14.
Lock acquire reduced 18% to 10%
10.49 %postgres postgres[.] LWLockAcquire
5.09% postgres postgres[.] _bt_compare
Is lock contention can be reduced to 0-3%?
On pg-stat-activity shown LwLock as “BufferCounter” and “WalIn
Tom, David,
Thank you for the time and information.
I lost my system this morning, so I need to re-establish a system and do
some additional homework.
Thanks again.
-Tim
BTW: here is the definition of the pworkspaceobject table.
tc=# \d+ pworkspaceobject
Table "public.p
