4 ms·
You can do something better for 0$, just install the TimescaleDB postgres extension and execute: SELECT create_hypertable('public.challenge_1br', by_range('tim
by rthnbgrredf 3y ago
You can do something better for 0$, just install the TimescaleDB postgres extension and execute:
SELECT create_hypertable('public.challenge_1br', by_range('time'));
Now, enjoy your better than Snowflake query performance performance at no extra cost.
- btown 3y agoIronically for many, the lack of support for arbitrary extensions on RDS, Google Cloud SQL, and the like means that if your data's stuck there, you'd need to migrate to a self-managed database instance - which means you'd need to use the strategies in the blog post anyways! More generally, of course, it's not always a "free lunch" to have your analytics compute using the same CPU/RAM that runs your production transactional database. If you're at billion-row scales, you're likely to be at the point where mirroring to a data warehouse is becoming necessary.
- rthnbgrredf 3y agoGoogle Cloud SQL does support quite a few postgres extension, but unfortunately it does not support TimescaleDB, that's quite sad indeed. I hope that at some point in the future TimescaleDB could be merged into postgres to make it a native feature.