ENUMs vs Check Constraints, Faceting With Roaring Bitmaps, Better Scaling, In DB Business Logic | Scaling Postgres 245

In this episode of Scaling Postgres, we discuss ENUMs vs. check constraints, querying table facets with roaring bitmaps, a better way to handle scaling and whether you should store your business logic in Postgres.

Content Discussed

• Enums vs Check Constraints in Postgres
• Faceting large result sets in PostgreSQL
• pgfaceting Extension
• Roaring Bitmaps and pgfaceting: Fast counting across large datasets in Postgres
• ISO Better Scaling, Instacart Drops Postgres for Amazon DynamoDB
• Rubber Duck Dev Show Episode 68 | Should You Store Business Logic In Your Database?
• Debugging Postgres WAL events with pg_walinspect
• The bountiful world of Postgres indexing options
• PGSQL Phriday #003: What is the PostgreSQL Community to me
• Postgres support for JSON is 10 years old!
• Timestamps
• Aleš Zelený

YouTube Video

Podcast Audio