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!
[ Parent
| on HN ]
There are no comments on this comment yet.