News for hackers. Stuff that matters.
Re:Building a scalable time-series database on PostgreSQL by sciurus on Tuesday April 04, 2017 @03:45PM (#14036489)
If your main use case for timeseries is a graphite/statsd replacement, another PostgesSQL-based project worth looking at is tgres.

https://grisha.org/blog/2017/03/22/tgres-0-dot-10-dot-0b-tim...

https://github.com/tgres/tgres

Re:Building a scalable time-series database on PostgreSQL by gtrubetskoy on Tuesday April 04, 2017 @05:31PM (#14037411)
And Tgres requires no extensions to Postgres, you can use Postgres as-is (I know because I wrote it :) ).

I'd also add the link to the post explaining the principle of how time series is actually stored which makes it capable of receiving 150K+ data points per second on relatively small hardware:

https://grisha.org/blog/2017/01/21/storing-time-seris-in-pos...

Fundamentally though, what timescale does is different in that they store (as far as I can tell) every incoming data point, which is more of a "big data" problem, whereas Tgres is all about what you can do with Postgres if you make the series regular (i.e. evenly spaced) on the fly and store time series as round-robin archives of fixed resolution and span, so I don't think comparing Tgres and Timescale makes a lot of sense.

Re:Building a scalable time-series database on PostgreSQL by JimNasby on Saturday April 08, 2017 @04:58PM (#14069001)
Not sure what you're trying to say about "requires no extensions"; Timescale is an extension that doesn't modify Postgres itself, similar to Citus, and very different from XL/XC, GreenPlum, or EnterpriseDB's proprietary offerings.
Re:Building a scalable time-series database on PostgreSQL by gtrubetskoy on Tuesday April 11, 2017 @09:37AM (#14087580)
I simply mean that no CREATE EXTENSION is necessary.