Building a distributed time-series database on PostgreSQL

Re:Building a distributed time-series database on PostgreSQL by WireBaron on Wednesday August 21, 2019 @04:02PM (#20761085)

We actually haven't been running against any limits here. One thing to keep in mind is that postgres remote-fetch operations aren't tuple-at-a-time, so this shouldn't be a bottleneck for our multi-node operations.

[ Parent | on HN ]

Re:Building a distributed time-series database on PostgreSQL by ryanworl on Wednesday August 21, 2019 @04:10PM (#20761160)

Have you done any analysis of your per-core scan rates for simple aggregations like sum/count + group by with a reasonably large cardinality key? Or has anyone published a benchmark you trust on queries of that variety?

An example would be TPC-H Q1, which is a little weak on the group by cardinality, but is good for testing raw aggregation performance.

[ Parent | on HN ]

Re:Building a distributed time-series database on PostgreSQL by WireBaron on Wednesday August 21, 2019 @04:29PM (#20761375)

We actually have done fairly extensive benchmarking of high cardinality data on our single-node product (we have a blog entry detailing at least our insert performance here: https://blog.timescale.com/blog/what-is-high-cardinality-how...)

We're actually currently focused on query optimization for our multi-node product, but we don't have any numbers we're currently ready to share.

[ Parent | on HN ]