Re: Speed up transaction completion faster after many relations are accessed in a transaction

Поиск
Список
Период
Сортировка
Искать
От
Yura Sokolov
Тема
Re: Speed up transaction completion faster after many relations are accessed in a transaction
Дата
Msg-id
df6b68c68244bd61cd044a59115d699e6c42246f.camel@postgrespro.ru
Ответ на
Список
Дерево обсуждения
Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Simon Riggs <simon@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction 'Andres Freund' <andres@anarazel.de>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tom Lane <tgl@sss.pgh.pa.us>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Thomas Munro <thomas.munro@gmail.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Alvaro Herrera <alvherre@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Alvaro Herrera <alvherre@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Michael Paquier <michael@paquier.xyz>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Yura Sokolov <y.sokolov@postgrespro.ru>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Michael Paquier <michael@paquier.xyz>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Michael Paquier <michael@paquier.xyz>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Zhihong Yu <zyu@yugabyte.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Yura Sokolov <y.sokolov@postgrespro.ru>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Jacob Champion <jchampion@timescale.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Ankit Kumar Pandey <itsankitkp@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction vignesh C <vignesh21@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Amit Langote <amitlangote09@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi>
Re: Speed up transaction completion faster after many relations are accessed in a transaction vignesh C <vignesh21@gmail.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Heikki Linnakangas <hlinnaka@iki.fi>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations are accessed in a transaction Zhihong Yu <zyu@yugabyte.com>
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley <dgrowleyml@gmail.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Andres Freund <andres@anarazel.de>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction David Rowley <david.rowley@2ndquadrant.com>
Re: Speed up transaction completion faster after many relations areaccessed in a transaction Tomas Vondra <tomas.vondra@2ndquadrant.com>
RE: Speed up transaction completion faster after many relations areaccessed in a transaction "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Good day, David.

I'm looking on patch and don't get some moments.

`GrantLockLocal` allocates `LOCALLOCKOWNER` and links it into
`locallock->locallockowners`. It links it regardless `owner` could be
NULL. But then `RemoveLocalLock` does `Assert(locallockowner->owner != NULL);`.
Why it should not fail?

`GrantLockLocal` allocates `LOCALLOCKOWNER` in `TopMemoryContext`.
But there is single `pfree(locallockowner)` in `LockReassignOwner`.
Looks like there should be more `pfree`. Shouldn't they?

`GrantLockLocal` does `dlist_push_tail`, but isn't it better to
do `dlist_push_head`? Resource owners usually form stack, so usually
when owner searches for itself it is last added to list.
Then `dlist_foreach` will find it sooner if it were added to the head.

regards

---------

Yura Sokolov
Postgres Professional
y.sokolov@postgrespro.ru
funny.falcon@gmail.com




В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Alvaro Herrera
Дата:
FAQ