Re: PostgreSQL VS MongoDB: a use case comparison

Greetings,

* Merlin Moncure (mmoncure(at)gmail(dot)com) wrote:
> On Tue, Nov 20, 2018 at 11:28 AM Stephen Frost <sfrost(at)snowman(dot)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