Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

From: Andrew Staller <andrew(at)timescale(dot)com>
To: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
Cc: Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: A Timeseries Case Study: InfluxDB VS PostgreSQL
Date: 2018-09-07 19:08:18
Message-ID: 6b25525b-8c36-620e-5da0-c900a7720c19@mixmax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,
Full disclosure: I'm a Timescale employee. Fabio, really interesting analysis
and we can generally confirm the conclusions of your tests.
As Thomas pointed out above, TimescaleDB is an open-source time-series database
packaged as Postgres extension. We are always interested in performance
comparisons between TimescaleDB and vanilla Postgres and have run a few
ourselves (compared to 9.6 and insert rates/ease-of-use in PG10). We'll of
course be looking at comparisons to PG11 and where improvements in PG11 also
carry over to TimescaleDB. Third-party comparisons are also welcome, especially
from someone well-acquainted with Postgres.
We have also run benchmarks comparing TimescaleDB and MongoDB that might be
useful/interesting for folks here:
https://blog.timescale.com/how-to-store-time-series-data-mongodb-vs-timescaledb-postgresql-a73939734016
And in reference to the earlier discussion of InfluxDB, here's a similar post
comparing TimescaleDB with InfluxDB:
https://blog.timescale.com/timescaledb-vs-influxdb-for-time-series-data-timescale-influx-sql-nosql-36489299877
Finally, if you're interested, here's the open source tool we use to run our
database comparison benchmarks: https://github.com/timescale/tsbs
Let me know if you have any TimescaleDB specific questions!

On Fri, Sep 7, 2018 4:08 AM, Benjamin Scherrey scherrey(at)proteus-tech(dot)com wrote:
Interesting and useful article, Fabio. I'm actually quite curious about your
evaluation of MongoDB & Postgres. I've been operating under the opinion that
MongoDB has been obsoleted in every respect by Postgres and am curious as to
whether there are any credible use cases where, given the opportunity to choose
from the beginning which technology to build a new product on, I would ever
select MongoDB over Postgres given the choice between them.
best regards,
- - Ben Scherrey
On Fri, Sep 7, 2018, 5:16 PM Fabio Pardi <f(dot)pardi(at)portavita(dot)eu> wrote:
Hi Achilleas,

I'm glad you like the article.

Probably I will find the time to come back to the topic when I'm done comparing
Mongodb with PostgreSQL

regards,

fabio pardi

On 07/09/18 11:18, Achilleas Mantzios wrote:
> Nice read! Wonder if you could repeat the tests on pgsql 10.5 and btree/BRIN.

TimescaleDB | Head of Marketing & Communityc: 908.581.9509
335 Madison Ave.New York, NY 10017http://www.timescale.com/
https://github.com/timescale/timescaledb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Steele 2018-09-07 22:22:43 Re: pgbackrest when data/base is symlinked to another volume
Previous Message Adam Brusselback 2018-09-07 14:28:27 Re: Re: Re: How to install pgAgent on windows for postresql-bigsql-10.5