| From: | "Joel Jacobson" <joel(at)compiler(dot)org> |
|---|---|
| To: | "Oleg Bartunov" <obartunov(at)postgrespro(dot)ru>, "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | "Dmitry Dolgov" <9erthalion6(at)gmail(dot)com>, "PostgreSQL Hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, akorotkov(at)postgresql(dot)org |
| Subject: | Re: jsonb subscripting assignment performance |
| Date: | 2021-04-14 10:53:49 |
| Message-ID: | df43c77b-883d-4422-b963-ecfe55d4801b@www.fastmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | e.sokolova | 2021-04-14 11:27:36 | Re: [PATCH] Add extra statistics to explain for Nested Loop |
| Previous Message | Himanshu Upadhyaya | 2021-04-14 10:45:27 | Re: [PATCH] PREPARE TRANSACTION unexpected behavior with TEMP TABLE |