PGConf NYC 2021 - Advanced Postgres Schema Design... by Sehrope Sarkuni
Advanced Postgres Schema Design (For Scalable Application Development) bySehrope Sarkuni
Go beyond CREATE TABLE and CREATE VIEW with functional indexes, exclusion constraints, array types, transactional DDL, and more for simple, scalable application development.
In this talk, we'll go into PostgreSQL-specific features that can be leveraged for advanced schema design. The focus will be solving real-world problems faced by application developers to create long-lasting database schemas.