Build Your Business Based On PostgreSQL Databases
summary
Ebiquity’s Digital Innovation Center runs PostgreSQL as the central store, migrating from a single node to PostgreSQL 13 on Azure Flexible Server and keeping Databricks for ingestion and Airflow for orchestration. The deployment holds 2.7 trillion impressions, ingests ~70 million rows/month, serves 40+ live databases and 60+ Power BI dashboards from ~2 TB, and uses postgres_fdw, trigger functions, constraints, calculated columns and indexes for enrichment, auditing and deduplication; migration yields ~80–90% faster creative query times.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 2:06History of the Digital Information Center
- 4:06Exponential Growth with PostgreSQL
- 5:09Tech Landscape at Ebiquity
- 8:55Migrating from a single node to Azure Flexible Server
- 12:20Trigger functions
- 14:03Constraints
- 15:29Foreign data wrappers & calculated columns
- 17:17Indexes
- 18:02Key Takeaways
related talks
25mWhat’s New with Azure Database for PostgreSQL- Flexible Server
46mBig databases, many servers, data center or cloud - it's all here!
26mWhat Enterprises like about Azure Database for PostgreSQL - Flexible Server
31mBuild scalable and secure enterprise apps on OSS databases Q&A
57mDeveloping powerful and intelligent apps using the Azure managed PostgreSQL service
15mBuilding for the Future and Betting Big on Postgres
24mPostgres-powered AI: Running an End-to-End AI Platform with Postgres on Azure
32mWhat makes Azure Database for PostgreSQL Great for Developers?