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 315

May 12, 2024 00:19:31
Episode Cover

Hacking On Postgres is Hard! | Scaling Postgres 315

In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metrics...

Listen

Episode 293

December 04, 2023 00:15:18
Episode Cover

Better Plans With Statistics | Scaling Postgres 293

In this episode of Scaling Postgres, we discuss how create statistics can help you get better plans, issues with subtransactions, all about extensions and...

Listen

Episode 215

May 15, 2022 00:17:13
Episode Cover

New Releases, AlloyDB, Time Zones, Connecting to Postgres | Scaling Postgres 215

In this episode of Scaling Postgres, we discuss parallel server-side backup compression, IO in Postgres, parquet files and the new pg_stat_monitor extension. To get...

Listen