
Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253
Get New Episodes Weekly!
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