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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: How we made Postgres upserts 2-3* quicker than MongoDB
Дата
Msg-id CAOR=d=3_xRdttZL8uJ6T+gcN3WCaMm=-5o130Kj7SVGVwP23QQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How we made Postgres upserts 2-3* quicker than MongoDB  (Nicolas Paris <niparisco@gmail.com>)
Список pgsql-performance
On Fri, Jan 8, 2016 at 10:07 AM, Nicolas Paris <niparisco@gmail.com> wrote:
>
> 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

> 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,

I think the part where he mentioned that it's a lot easy to do roll up
and reporting queries etc. on a sql database justified the comparison
between the two in general. At which point PostgreSQL would normally
be considered the underdog in write performance, at least in the past.
So comparing the two makes perfect sense.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Zealey
Дата:
Сообщение: Re: How we made Postgres upserts 2-3* quicker than MongoDB
Следующее
От: Jinhua Luo
Дата:
Сообщение: insert performance