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 362

April 20, 2025 00:12:22
Episode Cover

Optimizing For Time-Series Data | Scaling Postgres 362

In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data...

Listen

Episode 94

December 16, 2019 00:12:29
Episode Cover

State of Postgres, Dumping DBs, Configuration Parameters, Partial WAL | Scaling Postgres 94

In this episode of Scaling Postgres, we discuss the State of Postgres, how best to dump your database, setting configuration parameters and managing partial...

Listen

Episode 192

November 23, 2021 00:12:39
Episode Cover

Foreign Key Indexes, Graph Queries, Linux Huge Pages, Text Column Size | Scaling Postgres 192

In this episode of Scaling Postgres, we discuss if foreign keys should have indexes, how to run graph queries, how to configure Linux huge...

Listen