Unlogged Tables, pg_stat_io, Type Constraints, Text Types

Scaling Postgres

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

Feb 19 2023 | 00:16:25

00:00 / 00:16:25

Hosted By

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 224

July 18, 2022 • 00:13:57

Column Performance, BRIN Win, Unique and Null, Parallel Distinct | Scaling Postgres 224

In this episode of Scaling Postgres, we discuss how too many columns in a table can affect performance, at what point BRIN indexes win...

Episode 247

January 11, 2023 • 00:14:25

Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes | Scaling Postgres 247

In this episode of Scaling Postgres, we discuss how to generate test data, how WAL archiving is faster in PG15, how to set date...

Episode 406

March 01, 2026 • 00:18:21

Lock Causes Data To Vanish! | Scaling Postgres 406

In this episode of Scaling Postgres, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and...