News for hackers. Stuff that matters.
Re:ListenBrainz moves to TimescaleDB by jarym on Wednesday July 22, 2020 @02:32PM (#23920122)
Have you been following ZHeap and do you think Timescale will benefit from a storage engine like that (less write amplification)?
Re:ListenBrainz moves to TimescaleDB by Lockerman on Wednesday July 22, 2020 @03:25PM (#23920605)
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.
Re:ListenBrainz moves to TimescaleDB by enordstr on Wednesday July 22, 2020 @05:16PM (#23921682)
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.
Re:ListenBrainz moves to TimescaleDB by jarym on Saturday August 01, 2020 @04:13PM (#24023528)
Nice! Thanks. Postgres is just amazing in so many respects. The work you guys do contribute to that.