pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-performance@lists.postgresql.org
Subject: Re: PostgreSQL VS MongoDB: a use case comparison
Date: Wed, 21 Nov 2018 07:48:05 +0100
Message-ID: <aab499b1-10f4-8a71-5dfe-16b91fbe0e96@gmx.net> (raw)
In-Reply-To: <20181120172829.GF3415@tamriel.snowman.net>
References: <d43fd220-09f7-af4c-2623-44f094b15115@portavita.eu>
	<20181119172609.GR3415@tamriel.snowman.net>
	<CAHyXU0wQKaoQsZL=adB5vCFhjL+2kn4DiRnmVDEABJC8aCAz0w@mail.gmail.com>
	<20181120164325.GE3415@tamriel.snowman.net>
	<CAHyXU0yUVXobs=GssyY9soXTDOQX1=r1rt5x5Ek=0hE4pdZoAg@mail.gmail.com>
	<20181120172829.GF3415@tamriel.snowman.net>

Stephen Frost schrieb am 20.11.2018 um 18:28:
> Oh yes, having a dictionary would be a great start to reducing the size
> of the jsonb data, though it could then become a contention point if
> there's a lot of new values being inserted and such.  Naturally there
> would also be a cost to pulling that data back out as well but likely it
> would be well worth the benefit of not having to store the field names
> repeatedly.

There is an extension for a dictionary based JSONB compression:

https://github.com/postgrespro/zson





view thread (14+ messages)  latest in thread

Message-ID: <aab499b1-10f4-8a71-5dfe-16b91fbe0e96@gmx.net>
Permalink:  ../aab499b1-10f4-8a71-5dfe-16b91fbe0e96@gmx.net/
Also on:    postgresql.org/message-id/aab499b1-10f4-8a71-5dfe-16b91fbe0e96@gmx.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: spam_eater@gmx.net, pgsql-performance@lists.postgresql.org
  Subject: Re: PostgreSQL VS MongoDB: a use case comparison
  In-Reply-To: <aab499b1-10f4-8a71-5dfe-16b91fbe0e96@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox