Re: PostgreSQL VS MongoDB: a use case comparison

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: PostgreSQL VS MongoDB: a use case comparison
Дата
Msg-id 20181120194659.GJ3415@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: PostgreSQL VS MongoDB: a use case comparison  (Merlin Moncure <mmoncure@gmail.com>)
Список 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

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: PostgreSQL VS MongoDB: a use case comparison
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: PostgreSQL VS MongoDB: a use case comparison