Advanced Postgres Schema Design for Scalable Application Development

Explore advanced PostgreSQL schema design techniques for scalable application development in this 48-minute conference talk from PGConf NYC 2021. Delve into PostgreSQL-specific features that go beyond basic CREATE TABLE and CREATE VIEW statements, including functional indexes, exclusion constraints, array types, and transactional DDL. Learn how to leverage these powerful tools to solve real-world problems faced by application developers and create robust, long-lasting database schemas. Gain insights into implementing advanced schema design strategies that enhance the scalability and performance of your PostgreSQL-based applications.