Re: Lock contention high
От
Mladen Gogala
Тема
Re: Lock contention high
Дата
Msg-id
938bdd7b-9a0d-1675-2c6c-ed1420f42b32@gmail.com
Ответ на
Lock contention high (Ashkil Dighin)
Список
Дерево обсуждения
Lock contention high Ashkil Dighin <ashkildighin76@gmail.com>
Re: Lock contention high Justin Pryzby <pryzby@telsasoft.com>
Re: Lock contention high MichaelDBA <MichaelDBA@sqlexec.com>
Re: Lock contention high Andres Freund <andres@anarazel.de>
Re: Lock contention high Ashkil Dighin <ashkildighin76@gmail.com>
Re: Lock contention high Andres Freund <andres@anarazel.de>
Re: Lock contention high Ashkil Dighin <ashkildighin76@gmail.com>
Re: Lock contention high Tom Lane <tgl@sss.pgh.pa.us>
Re: Lock contention high arjun shetty <arjunshetty955@gmail.com>
Re: Lock contention high arjun shetty <arjunshetty955@gmail.com>
Re: Lock contention high Michael Lewis <mlewis@entrata.com>
Re: Lock contention high Andres Freund <andres@anarazel.de>
Re: Lock contention high Mikhail Zhilin <zhilin.ms@phystech.edu>
Re: Lock contention high Ashkil Dighin <ashkildighin76@gmail.com>
Re: Lock contention high Mikhail Zhilin <zhilin.ms@phystech.edu>
Re: Lock contention high Mladen Gogala <gogala.mladen@gmail.com>
Re: Lock contention high Jeremy Schneider <schneider@ardentperf.com>
Re: Lock contention high Peter Geoghegan <pg@bowt.ie>
Re: Lock contention high Peter Geoghegan <pg@bowt.ie>
Re: Lock contention high Ashkil Dighin <ashkildighin76@gmail.com>
On 10/12/21 03:35, Ashkil Dighin wrote:
1.Is there a way to tune the lock contention ?
Lock contention is usually an application issue. Application processes are stepping on each other's toes. I have never seen a situation where the database would be slow with managing locks. Postgres uses an in-memory queue manager which is, generally speaking, very fast. Applications usually do stupid things. I've seen GUI doing "SELECT FOR UPDATE". And then the operator decided to have lunch. I'll leave the rest to your imagination.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
В списке pgsql-performance по дате отправления
