On Mon, Jun 19, 2017 at 2:29 PM, Rob Nikander wrote:
> I'm wondering about the tradeoffs, specifically: is it possible to update
> one piece of a jsonb value without having to rewrite the entire field? There
> are cases where that data field was getting pretty big (500kb). Would you
> expect any o
> On 19 June 2017 at 21:29, Rob Nikander wrote:
>
> I'm wondering about the tradeoffs, specifically: is it possible to update
one piece of a jsonb value without having to rewrite the entire field?
There are cases where that data field was getting pretty big (500kb). Would
you expect any obvious pe
Am 19. Juni 2017 21:29:40 MESZ schrieb Rob Nikander :
>
>I'm wondering about the tradeoffs, specifically: is it possible to
>update one piece of a jsonb value without having to rewrite the entire
>field?
Updates in PostgreSQL are always Delete & Insert. So the answer is no. For
session-data pl
Hi,
I’ve got a web app where I want to store user’s session data. The schema in
this data changes a lot so it may be useful here to store the session
properties in either a jsonb column, or in multiple rows. Something like:
session_id | data
100 { a: 1, bar: 2 ...
101 {
