Re: [GENERAL] performance considerations of jsonb vs separate rows - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [GENERAL] performance considerations of jsonb vs separate rows
Date
Msg-id BD973C92-9AA6-4790-A5F4-6033D159F213@a-kretschmer.de
Whole thread Raw
In response to [GENERAL] performance considerations of jsonb vs separate rows  (Rob Nikander <rob.nikander@gmail.com>)
List pgsql-general
Am 19. Juni 2017 21:29:40 MESZ schrieb Rob Nikander <rob.nikander@gmail.com>:

>
>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 please consider unlogged
tables.


Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company


pgsql-general by date:

Previous
From: Rob Nikander
Date:
Subject: [GENERAL] performance considerations of jsonb vs separate rows
Next
From: Dmitry Dolgov
Date:
Subject: Re: [GENERAL] performance considerations of jsonb vs separate rows