Re:Building a distributed time-series database on PostgreSQL
by manigandham on Wednesday August 21, 2019 @07:07PM
(#20762890)
There are other relational databases like MemSQL or Clickhouse that use distributed column-oriented architectures that are much better at large scale analytics and aggregations.
Postgres is getting pluggable storage engines in the next version (and already has foreign data wrappers) so that can at least lead to a better storage design.
Re:Building a distributed time-series database on PostgreSQL
by einpoklum on Wednesday August 21, 2019 @07:25PM
(#20763014)
It's not just my point of view - it's well known in the research community, and has been for decades.
For FOSS, have a look at MonetDB. For research-oriented systems, look for publications regarding HyperDB or VectorWise/Actian Vector (VectorH in the cluster version). Other commercial offerings are Vertica (formerly C-Store) and SAP Hana.
PostgreSQL is not even something anyone compares against in analytics...
Re:Building a distributed time-series database on PostgreSQL
by einpoklum on Thursday August 22, 2019 @02:26AM
(#20765215)
Oh yea, MemSQL and ClickHouse are also indeed relevant and in this category, except that ClickHouse doesn't support all of SQL and any table structure, so it's not a full-fledged DBMS.
In my experience, being able to do advanced ad-hoc SQL queries is priceless for analytics. Timescale helps in scaling time series use-cases that used to scale badly in plain PostgreSQL.