From: Mark Zealey <mark@allaroundtheworld.fr>
To: Nicolas Paris <niparisco@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: How we made Postgres upserts 2-3* quicker than MongoDB
Date: Fri, 8 Jan 2016 19:16:34 +0200
Message-ID: <568FEEF2.2030603@allaroundtheworld.fr> (raw)
In-Reply-To: <CA+ssMOS9FCk-bn5WY0ctHMGOEu612HDsODytOB-qSLmbh9v-TQ@mail.gmail.com>
References: <568FE5D0.9040901@allaroundtheworld.fr>
<CA+ssMOS9FCk-bn5WY0ctHMGOEu612HDsODytOB-qSLmbh9v-TQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 08/01/16 19:07, Nicolas Paris wrote:
> 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 ?
Yes you can get better performance with mongo via the sharding route but
there are a number of quite bad downsides to mongo sharding - limited
ability to perform aggregation, loss of unique key constraints other
than the shard key, requires at minimum 4-6* the hardware (2 replicas
for each block = 4 + 2 * mongos gateway servers)... Actually pretty
similar to the issues you see when trying to scale a RDBMS via
sharding... We tried doing some mongo sharding and the result was a
massive drop in write performance so we gave up pretty quickly...
Mark
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark@allaroundtheworld.fr, niparisco@gmail.com
Subject: Re: How we made Postgres upserts 2-3* quicker than MongoDB
In-Reply-To: <568FEEF2.2030603@allaroundtheworld.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox