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

Episode 253 February 19, 2023 00:16:25
Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253
Scaling Postgres
Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253

Feb 19 2023 | 00:16:25

/

Hosted By

Creston Jamison

Show Notes

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.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com

Other Episodes

Episode 108

April 06, 2020 00:20:43
Episode Cover

Ten Things, Audit Triggers, Schema Design, High Availability | Scaling Postgres 108

In this episode of Scaling Postgres, we discuss ten things to hate about Postgres, audit trigger performance, designing a schema and the future of...

Listen

Episode 259

April 02, 2023 00:13:34
Episode Cover

Recovery Time, Lost Data, Production Ready, PG16 Highlights | Scaling Postgres 259

  In this episode of Scaling Postgres, we discuss max_wal_size as it relates to recovery time, losing your data with collation changes, getting production ready...

Listen

Episode 408

March 15, 2026 00:17:05
Episode Cover

Open Source Eating The World | Scaling Postgres 408

In this episode of Scaling Postgres, we discuss how open source is eating the world, mitigating plan flips, migrating from Heroku to RDS, and...

Listen