Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-29 Thread Oleg Bartunov
On Wed, Nov 21, 2018 at 9:48 AM Thomas Kellerer wrote: > > 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

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Thomas Kellerer
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

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Stephen Frost
Greetings, * Merlin Moncure (mmonc...@gmail.com) wrote: > On Tue, Nov 20, 2018 at 11:28 AM Stephen Frost 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

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Merlin Moncure
On Tue, Nov 20, 2018 at 11:28 AM Stephen Frost wrote: > > Greetings, > > * Merlin Moncure (mmonc...@gmail.com) wrote: > > On Tue, Nov 20, 2018 at 10:43 AM Stephen Frost wrote: > > > * Merlin Moncure (mmonc...@gmail.com) wrote: > > > > On Mon, Nov 19, 2018 at 11:26 AM Stephen Frost > > > >

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Stephen Frost
Greetings, * Merlin Moncure (mmonc...@gmail.com) wrote: > On Tue, Nov 20, 2018 at 10:43 AM Stephen Frost wrote: > > * Merlin Moncure (mmonc...@gmail.com) wrote: > > > On Mon, Nov 19, 2018 at 11:26 AM Stephen Frost wrote: > > > > Looks like a lot of the difference being seen and the comments

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Merlin Moncure
On Tue, Nov 20, 2018 at 10:43 AM Stephen Frost wrote: > > Greetings, > > * Merlin Moncure (mmonc...@gmail.com) wrote: > > On Mon, Nov 19, 2018 at 11:26 AM Stephen Frost wrote: > > > Looks like a lot of the difference being seen and the comments made > > > about one being faster than the other

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Stephen Frost
Greetings, * Merlin Moncure (mmonc...@gmail.com) wrote: > On Mon, Nov 19, 2018 at 11:26 AM Stephen Frost wrote: > > Looks like a lot of the difference being seen and the comments made > > about one being faster than the other are because one system is > > compressing *everything*, while PG

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Merlin Moncure
On Mon, Nov 19, 2018 at 11:26 AM Stephen Frost wrote: > Looks like a lot of the difference being seen and the comments made > about one being faster than the other are because one system is > compressing *everything*, while PG (quite intentionally...) only > compresses the data sometimes- once it

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Fabio Pardi
Hi again, On 11/20/18 2:34 PM, Stephen Frost wrote: >> I agree with you the compression is playing a role in the comparison. >> Probably there is a toll to pay when the load is high and the CPU >> stressed from de/compressing data. If we will be able to bring our >> studies that further, this is

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Stephen Frost
Greetings, * Fabio Pardi (f.pa...@portavita.eu) wrote: > thanks for your feedback. We prefer on these mailing lists to not top-post but instead to reply inline, as I'm doing here. This helps the conversation by eliminating unnecessary dialogue and being able to make comments regarding specific

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-20 Thread Fabio Pardi
Hi Stephen, thanks for your feedback. I agree with you the compression is playing a role in the comparison. Probably there is a toll to pay when the load is high and the CPU stressed from de/compressing data. If we will be able to bring our studies that further, this is definitely something we

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-19 Thread Stephen Frost
Greetings, * Fabio Pardi (f.pa...@portavita.eu) wrote: > We are open to any kind of feedback and we hope you enjoy the reading. Looks like a lot of the difference being seen and the comments made about one being faster than the other are because one system is compressing *everything*, while PG