In this tutorial, you used Hyperscale (Citus) on Azure Database for PostgreSQL and learned how to perform the following:
- Generate real-time load in the background
- Create Psql functions and update them
- Roll up data so your application will scale
- Expire old data
- Report on distinct counts
- Report top records using topn extension
- Visualize data using Power BI
- Contact us if you want to deploy a production workload with Hyperscale (Citus) at AskAzureDBforPostgreSQL@service.microsoft.com
- To deploy Hyperscale Citus cluster in your own subscription to test a real workload: https://docs.microsoft.com/en-us/azure/postgresql/quickstart-create-hyperscale-portal
- Citus and pg_partman: Creating a scalable time series database on Postgres
- GitHub - PostgreSQL Cron job
- GitHub - HLL HyperLogLog
- When to use unstructured datatypes in Postgres–Hstore vs. JSON vs. JSONB