Re: performance considerations of jsonb vs separate rows

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)postgresql(dot)org,Rob Nikander <rob(dot)nikander(at)gmail(dot)com>
Subject: Re: performance considerations of jsonb vs separate rows
Date: 2017-06-19 19:51:46
Message-ID: BD973C92-9AA6-4790-A5F4-6033D159F213@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 19. Juni 2017 21:29:40 MESZ schrieb Rob Nikander <rob(dot)nikander(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Dolgov 2017-06-19 19:52:54 Re: performance considerations of jsonb vs separate rows
Previous Message Rob Nikander 2017-06-19 19:29:40 performance considerations of jsonb vs separate rows