News for hackers. Stuff that matters.
Re:Announcing Timescale Cloud by dianasaur323 on Tuesday June 18, 2019 @08:32PM (#20219851)
Yeah - TimescaleDB comes with a time_bucket function that allows you to group things by minute, and specify a where clause that queries for just the last 5 days. You can build indexes that include the ticker, and also reorder data on disk to optimize how much data you scan on disk. So, TLDR - you should definitely try it! I did some quick googling, and it looks like Metabase supports PostgreSQL, so it should work with Timescale. We would love to hear how it goes!

There are no comments on this comment yet.