Postgres Pro
Downloads
Home   >   mailing lists

Re: How we made Postgres upserts 2-3* quicker than MongoDB - Mailing list pgsql-performance

From Nicolas Paris
Subject Re: How we made Postgres upserts 2-3* quicker than MongoDB
Date
Msg-id CA+ssMOS9FCk-bn5WY0ctHMGOEu612HDsODytOB-qSLmbh9v-TQ@mail.gmail.com
Whole thread Raw
In response to How we made Postgres upserts 2-3* quicker than MongoDB  (Mark Zealey <mark@allaroundtheworld.fr>)
Responses Re: How we made Postgres upserts 2-3* quicker than MongoDB  (Mark Zealey <mark@allaroundtheworld.fr>)
Re: How we made Postgres upserts 2-3* quicker than MongoDB  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view 
Hello Mark,

As far as I know, MongoDB is able to get better writing performances
thanks to scaling (easy to manage sharding). Postgresql cannot (is not
designed for - complicated).
Why comparing postgresql & mongoDB performances on a standalone
instance since mongoDB is not really designed for that ?

Thanks for the answer and for sharing,


2016-01-08 17:37 GMT+01:00 Mark Zealey <mark@allaroundtheworld.fr>:
> Hi all, I just wrote an article about the postgres performance optimizations
> I've been working on recently especially compared to our old MongoDB
> platform
>
> https://mark.zealey.org/2016/01/08/how-we-tweaked-postgres-upsert-performance-to-be-2-3-faster-than-mongodb
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Mark Zealey
Date:
Subject: How we made Postgres upserts 2-3* quicker than MongoDB
Next
From: Mark Zealey
Date:
Subject: Re: How we made Postgres upserts 2-3* quicker than MongoDB