jsonb_delete with arrays

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема jsonb_delete with arrays
Дата
Msg-id CABUevEyvMa2wKntZ9bcgJo_cYFPR+TNHJQkUm3nb+D8+5XwaTg@mail.gmail.com
обсуждение исходный текст
Ответы Re: jsonb_delete with arrays
Список 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.
Вложения

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

Предыдущее
От: Kuntal Ghosh
Дата:
Сообщение: Re: WAL consistency check facility
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Snapshot too old logging