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.