| From: | Magnus Hagander <magnus(at)hagander(dot)net> | 
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | jsonb_delete with arrays | 
| Date: | 2016-11-15 15:53:41 | 
| Message-ID: | CABUevEyvMa2wKntZ9bcgJo_cYFPR+TNHJQkUm3nb+D8+5XwaTg@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Attached is an implantation of jsonb_delete that instead of taking a single
key to remove accepts an array of keys (it still does just keys, so it's
using the - operator, it's not like the path delete function that also
takes an array, but uses a different operator).
In some simple testing of working through a real world usecases where we
needed to delete 7 keys from jsonb data, it shows approximately a 9x
speedup over calling the - operator multiple times. I'm guessing since we
copy a lot less and don't have to re-traverse the structure.
-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/
| Attachment | Content-Type | Size | 
|---|---|---|
| jsonb_delete_array.patch | text/x-patch | 6.3 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2016-11-15 16:20:39 | Re: Snapshot too old logging | 
| Previous Message | Kuntal Ghosh | 2016-11-15 15:50:21 | Re: WAL consistency check facility |