If I have to specify the entire JSON value, this means that the update query replaces the entire row instead of updating a single field. Is this correct?
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.
From:
Aleksander Kamenik Date: Subject:
[ADMIN] Re: pg_current_xlog*_location and pg_stat_replication.replay_location> 0 for synced replication connection