Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253

In this episode of Scaling Postgres, we discuss working with unlogged tables, the new pg_stat_io feature, handling complex type constraints and choosing the best text type.

Content Discussed

• PostgreSQL Unlogged Tables - Look Ma, No WAL!
• Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io
• Type Constraints in 65 lines of SQL
• Should You Use char, varchar, or text in PostgreSQL?
• UUIDs vs serials for keys
• Avoid Postgres performance cliffs with MultiXact IDs and foreign keys
• PostgreSQL Patch of Interest (to me): Using the System CA Pool for Certificate Verification
• PostgreSQL: Finding the current timestamp
• Get the most out of PostgreSQL using psql with must known features.
• Ranking Data with SQL Window Functions
• Exploring Row Level Security In PostgreSQL
• Postgres WAL Files and Sequence Numbers
• Listen to Database Changes with Postgres Triggers and Elixir
• Go & PostgreSQL: FOSDEM 2023 talk
• Storing Network Addresses in Oracle vs PostgreSQL vs SQL Server
• Real-time analytics
• Takamichi Osumi
• Getting Stuff Done With Drew Bragg | Rubber Duck Dev Show 74

YouTube Video