Re: The Curious Case of the Table-Locking UPDATE Query

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: The Curious Case of the Table-Locking UPDATE Query
Дата
Msg-id 20210708174224.GA9739@depesz.com
обсуждение исходный текст
Ответ на The Curious Case of the Table-Locking UPDATE Query  (Emiliano Saenz <saenz.emi.jos@gmail.com>)
Ответы Re: The Curious Case of the Table-Locking UPDATE Query
Список pgsql-general
Дерево обсуждения 
On Thu, Jul 08, 2021 at 02:35:33PM -0300, Emiliano Saenz wrote:
> Attach the files.

The pg_locks file doesn't show any access exclusive locks on any table?

=$ awk -F, 'NR==1 || $13 == "AccessExclusiveLock"' pg_locks.csv 

Locktype,Database,Relation,Page,Tuple,Virtualxid,Transactionid,Classid,Objid,Objsubid,Virtualtransaction,Pid,Mode,Granted,Fastpath
tuple,248043888,248044255,213071,39,NULL,NULL,NULL,NULL,NULL,198/814,21038,AccessExclusiveLock,f,f
tuple,248043888,248044255,213071,39,NULL,NULL,NULL,NULL,NULL,34/90197,21187,AccessExclusiveLock,t,f
tuple,248043888,248044255,213071,39,NULL,NULL,NULL,NULL,NULL,132/957,21007,AccessExclusiveLock,f,f

As you can see all the AccessExclusive locks are on tuples (rows).

Best regards,

depesz

В списке pgsql-general по дате отправления: