Re: jsonb subscripting assignment performance

Поиск

Список

Период

Сортировка

От	Joel Jacobson
Тема	Re: jsonb subscripting assignment performance
Дата	14 апреля 2021 г. 13:53:49
Msg-id	df43c77b-883d-4422-b963-ecfe55d4801b@www.fastmail.com обсуждение исходный текст
Ответ на	Re: jsonb subscripting assignment performance (Oleg Bartunov <obartunov@postgrespro.ru>)
Список	pgsql-hackers

On Wed, Apr 14, 2021, at 11:07, Oleg Bartunov wrote:

I and Nikita are working on OLTP jsonb http://www.sai.msu.su/~megera/postgres/talks/jsonb-pgconfonline-2021.pdf

Page 49/55 in the PDF:

"UPDATE test_toast SET jb = jsonb_set(jb, {keyN,0}, ?);"

Would you get similar improvements if updating jsonb variables in PL/pgSQL?

If not, could the infrastructure somehow be reused to improve the PL/pgSQL use-case as well?

I would be happy to help out if there is something I can do, such as testing.

/Joel

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

От: Himanshu Upadhyaya
Дата: 14 апреля 2021 г., 13:45:27
Сообщение: Re: [PATCH] PREPARE TRANSACTION unexpected behavior with TEMP TABLE

От: e.sokolova@postgrespro.ru
Дата: 14 апреля 2021 г., 14:27:36
Сообщение: Re: [PATCH] Add extra statistics to explain for Nested Loop