Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB
Дата
Msg-id CAKFQuwaBRkMYUH-frGJ+koH6=AoVWyTrOSxDugeE4-7jsZv4TA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB  (Keith <keith@keithf4.com>)
Ответы Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB  (Wei Shan <weishan.ang@gmail.com>)
Список pgsql-admin
On Mon, Aug 28, 2017 at 7:06 AM, Keith <keith@keithf4.com> wrote:
On Mon, Aug 28, 2017 at 9:46 AM, Wei Shan <weishan.ang@gmail.com> wrote:
Is this the most efficient way to do it? I'm not sure because this is basically replacing the entire JSON object instead of updating a single field.


keith@keith=# UPDATE json_data SET data = jsonb_set(data, '{account_balance}', '1'::jsonb, false);

​This.  Note still that in a MVCC (multi-version concurrency controlling) database you never really just update something in place since the old something has to continue to exist at the same time as the new something - at least for a little while.

David J.​

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

Предыдущее
От: Keith
Дата:
Сообщение: Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB
Следующее
От: Don Seiler
Дата:
Сообщение: [ADMIN] Why is my table not autovacuuming?