Re: PostgreSQL VS MongoDB: a use case comparison - Mailing list pgsql-performance

From Stephen Frost
Subject Re: PostgreSQL VS MongoDB: a use case comparison
Date
Msg-id 20181120194659.GJ3415@tamriel.snowman.net
Whole thread Raw
In response to Re: PostgreSQL VS MongoDB: a use case comparison  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
Greetings,

* Merlin Moncure (mmoncure@gmail.com) wrote:
> On Tue, Nov 20, 2018 at 11:28 AM Stephen Frost <sfrost@snowman.net> wrote:
> > 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.
>
> Yes, the biggest concern with a shared dictionary ought to be
> concurrency type problems.

Hmmm, I wonder if we could do something like have a dictionary per
page..  Or perhaps based on some hash of the toast ID..  Not sure. :)

Thanks!

Stephen

Attachment

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PostgreSQL VS MongoDB: a use case comparison
Next
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL VS MongoDB: a use case comparison