Scaling Postgres Episodes Page 7
Episodes on how best to scale your PostgreSQL relational database.
Scaling Postgres Episode 205 Indexing With tsearch, Tuples Not Yet Removable, Wicked Problems, Pattern Matching
In this episode of Scaling Postgres, we discuss the best ways to index with tsearch, what to check if tuples are not yet removable, wicked problems with Postgres and different pattern matching techniques.
Scaling Postgres Episode 204 Optimizing Trigram Search, Replication Review, Logical Improvements, Timescale Investment
In this episode of Scaling Postgres, we discuss optimizing trigram searches, a review of Postgres replication, improvements to logical replication and a significant Timescale investment.
Scaling Postgres Episode 202 New Postgres Releases, A Hairy Incident, Slow Down To Go Faster, Loadable Module Archiving
In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and using loadable modules for WAL archiving.