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.

Content Discussed

• Solving PostgreSQL wicked problems
• How to Cheat at WORDLE with PostgreSQL
• migra is a schema comparison tool for PostgreSQL.
• Pgpool-II Configuration Parameters - auto_failback
• Cloud Data Sources for the Postgres Operator for Kubernetes
• A snippet to acquire a Lightweight lock
• Gianni Ciolli
• Rubber Duck Dev Show Episode 32 | Reviewing the OWASP Top 5
• How to index data with tsearch?
• 5mins of Postgres E7: Autovacuum, dead tuples not yet removable, and the Postgres xmin horizon
• OrioleDB Github

YouTube Video