Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M53824=pgsql-performance-ar@postgresql.org>)
 id 1aHa4a-0004bX-0u
 for pgsql-performance@arkaria.postgresql.org; Fri, 08 Jan 2016 16:39:32 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-performance-owner+M53824=pgsql-performance-ar@postgresql.org>)
 id 1aHa4Z-0003zD-KC
 for pgsql-performance@arkaria.postgresql.org; Fri, 08 Jan 2016 16:39:31 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <mark@allaroundtheworld.fr>)
 id 1aHa2u-0000Hr-1T
 for pgsql-performance@postgresql.org; Fri, 08 Jan 2016 16:37:48 +0000
Received: from 8.mo2.mail-out.ovh.net ([188.165.52.147])
 by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <mark@allaroundtheworld.fr>)
 id 1aHa2q-0002bd-Ks
 for pgsql-performance@postgresql.org; Fri, 08 Jan 2016 16:37:46 +0000
Received: from mail135.ha.ovh.net (b6.ovh.net [213.186.33.56])
 by mo2.mail-out.ovh.net (Postfix) with SMTP id 663FAFFB9DA
 for <pgsql-performance@postgresql.org>; Fri,  8 Jan 2016 17:37:39 +0100 (CET)
Received: from localhost (HELO queueout) (127.0.0.1)
 by localhost with SMTP; 8 Jan 2016 18:37:39 +0200
Received: from unknown (HELO ?192.168.0.114?)
 (mark@allaroundtheworld.fr@88.253.62.92)
 by ns0.ovh.net with SMTP; 8 Jan 2016 18:37:38 +0200
To: pgsql-performance@postgresql.org
From: Mark Zealey <mark@allaroundtheworld.fr>
Subject: How we made Postgres upserts 2-3* quicker than MongoDB
Message-ID: <568FE5D0.9040901@allaroundtheworld.fr>
Date: Fri, 8 Jan 2016 18:37:36 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Ovh-Tracer-Id: 16560298781415128113
X-Ovh-Remote: 88.253.62.92 ()
X-Ovh-Local: 213.186.33.20 (ns0.ovh.net)
X-OVH-SPAMSTATE: OK
X-OVH-SPAMSCORE: 50
X-OVH-SPAMCAUSE: 
 gggruggvucftvghtrhhoucdtuddrfeekiedrjeehucetufdoteggodftvfcurfhrohhfihhlvgemucfqggfjnecuuegrihhlohhuthemuceftddtnecuogetfeejfedqtdegucdlhedtmd
X-VR-SPAMSTATE: OK
X-VR-SPAMSCORE: 50
X-VR-SPAMCAUSE: 
 gggruggvucftvghtrhhoucdtuddrfeekiedrjeehgdeludcutefuodetggdotffvucfrrhhofhhilhgvmecuqfggjfenuceurghilhhouhhtmecufedttdenucgoteefjeefqddtgeculdehtddm
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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