Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

[Andrew Staller <andrew@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxx 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.pardi@xxxxxxxxxxxx> 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 & Community

c: 908.581.9509

335 Madison Ave. 

New York, NY 10017

http://www.timescale.com/

https://github.com/timescale/timescaledb