Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

2018-09-07 Thread Andrew Staller
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 c

Re: How Many Partitions are Good Performing

2018-01-09 Thread Andrew Staller
This is the blog post that Rakesh referenced: https://blog.timescale.com/time-series-data-postgresql-10-vs-timescaledb-816ee808bac5 Please note, this analysis is done in the context of working with time-series data, where 1000s of chunks is not uncommon because of the append-mostly nature of the w

Re: Supartitions in PGSQL 10

2018-01-09 Thread Andrew Staller
Virenda, is this time-series data you're working with? On Mon, Jan 8, 2018 at 4:12 PM, Kumar, Virendra wrote: > Team, > > > > Can you please let us know if Sub-partitions are supported in PGSQL > (declarative partitions) 10.1. If yes can it be list-list partitions. We > have a situation where a