Latest Episodes
121
Fantastic Data Types, Domain Data Types, Insert Performance, Row Differences | Scaling Postgres 121
In this episode of Scaling Postgres, we discuss fantastic data types, custom domain data types, improving insert performance and how to query row differences....
120
Postgres 13 Beta 2, System Stats Extension, Tuned, Join Strategy | Scaling Postgres 120
In this episode of Scaling Postgres, we discuss Postgres 13 Beta 2, a system stats extension, tuning your operating systems for Postgres and different...
119
Replication Complications, One Word Performance, Pgbouncer Users, Serializable Isolation | Scaling Postgres 119
In this episode of Scaling Postgres, we discuss replication complications, adding one word to boost performance, handling pgbouncer users and serializable isolation testing. To...
118
Safety Systems, Failover Slots, Transaction ID Complications, Repartitioning | Scaling Postgres 118
In this episode of Scaling Postgres, we discuss safety systems, the purpose and existence of failover slots, complications with transaction IDs and how to...
117
Index Deduplication, Fast Hierarchy, More Monitoring, Cloud-Native | Scaling Postgres 117
In this episode of Scaling Postgres, we discuss index deduplication in Postgres 13, fast hierarchical access, more essential monitoring and cloud native Postgres. To...
116
Observer Effect, Partition Management, Tuple Freezing, Hung Transactions | Scaling Postgres 116
In this episode of Scaling Postgres, we discuss the observer effect with explain analyze, partition management, tuple freezing and sources of hung transactions. To...