[PERFORM] How we made Postgres upserts 2-3* quicker than MongoDB

2016-01-08 Thread Mark Zealey
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

Re: [PERFORM] How we made Postgres upserts 2-3* quicker than MongoDB

2016-01-08 Thread Nicolas Paris
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 tha

Re: [PERFORM] How we made Postgres upserts 2-3* quicker than MongoDB

2016-01-08 Thread Mark Zealey
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 si

Re: [PERFORM] How we made Postgres upserts 2-3* quicker than MongoDB

2016-01-08 Thread Scott Marlowe
On Fri, Jan 8, 2016 at 10:07 AM, Nicolas Paris wrote: > > 2016-01-08 17:37 GMT+01:00 Mark Zealey : >> 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/