Re:ListenBrainz moves to TimescaleDB
by zitterbewegung on Wednesday July 22, 2020 @11:10AM
(#23917848)
Have you thought of making a TimescaleDB app like the Postgres.app for macOS? Or could I use Postgres.app to make a TimescaleDB app?
It seems you can use the Postgres.app and install TimescaleDB on it
Here's some instructions on how to do so: https://github.com/slashdotdash/til/blob/master/postgres/ins...
Not sure if a coincidence, but someone just published this blog post today:
Installing Timescaledb on Mac OS X with Postgres.app https://prathamesh.tech/2020/07/23/installing-timescaledb-on...
Re:ListenBrainz moves to TimescaleDB
by rubyn00bie on Wednesday July 22, 2020 @12:27PM
(#23918704)
You can mount like any PostgreSQL version, including extensions, in Postgres.app. I’ve used both Timescale and Agens with it, with zero problems.
Have you been following ZHeap and do you think Timescale will benefit from a storage engine like that (less write amplification)?
Timescale engineer here. I'm betting we'll see a nice win; we tend to see write-mostly workloads the UNDO shouldn't be too expensive, and the smaller tuple sizes should be nice. We've built Timescale to be compatible with custom storage engines, so it should work as a drop-in, though of course until we've tested it we won't be sure.
Another Timescale engineer here. As previously pointed out, zheap should work as a drop-in in TimescaleDB. In fact, I just tried it and it works. However, it currently requires an unmerged PR to work properly: https://github.com/timescale/timescaledb/pull/2082, as well as further testing.
We first built TimescaleDB as "Postgres for time-series" for our own needs and then decided to open-source it for others. :-)