Re: POC: Lock updated tuples in tuple_update() and tuple_delete()

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: POC: Lock updated tuples in tuple_update() and tuple_delete()
Дата
Msg-id 20230307015029.dhxggojakwvkiyki@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: POC: Lock updated tuples in tuple_update() and tuple_delete()  (Pavel Borisov <pashkin.elfe@gmail.com>)
Ответы Re: POC: Lock updated tuples in tuple_update() and tuple_delete()  (Alexander Korotkov <aekorotkov@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Hi,

On 2023-03-02 14:28:56 +0400, Pavel Borisov wrote:
> 2. Heap updates with low tuple concurrency:
> Prepare with pkeys (pgbench -d postgres -i -I dtGvp -s 300 --unlogged-tables)
> Update 3*10^7 rows, 50 conns (pgbench postgres -f
> ./update-only-account.sql -s 300 -P10 -M prepared -T 600 -j 5 -c 50)
> 
> Result: Both patches and master are the same within a tolerance of
> less than 0.7%.

What exactly does that mean? I would definitely not want to accept a 0.7%
regression of the uncontended case to benefit the contended case here...

Greetings,

Andres Freund

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

Предыдущее
От: "Ryo Yamaji (Fujitsu)"
Дата:
Сообщение: RE: The order of queues in row lock is changed (not FIFO)
Следующее
От: Katsuragi Yuta
Дата:
Сообщение: Re: [Proposal] Add foreign-server health checks infrastructure