Re: jsonb subscripting assignment performance - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: jsonb subscripting assignment performance
Date
Msg-id df43c77b-883d-4422-b963-ecfe55d4801b@www.fastmail.com
Whole thread Raw
In response to Re: jsonb subscripting assignment performance  (Oleg Bartunov <obartunov@postgrespro.ru>)
List pgsql-hackers
On Wed, Apr 14, 2021, at 11:07, Oleg Bartunov wrote:

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 by date:

Previous
From: Himanshu Upadhyaya
Date:
Subject: Re: [PATCH] PREPARE TRANSACTION unexpected behavior with TEMP TABLE
Next
From: e.sokolova@postgrespro.ru
Date:
Subject: Re: [PATCH] Add extra statistics to explain for Nested Loop