Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.depesz.com/2022/03/01/how-to-index-data-with-tsearch/ https://pganalyze.com/blog/5mins-postgres-autovacuum-dead-tuples-not-yet-removable-postgres-xmin-horizon https://www.slideshare.net/AlexanderKorotkov/solving-postgresql-wicked-problems https://github.com/orioledb/orioledb https://blog.crunchydata.com/blog/how-to-cheat-at-wordle-with-postgresql https://databaseci.com/docs/migra https://b-peng.blogspot.com/2022/02/auto-failback.html https://blog.crunchydata.com/blog/cloud-data-sources-for-the-postgres-operator-for-kubernetes https://www.highgo.ca/2022/02/28/a-snippet-to-acquire-a-lightweight-lock/ https://postgresql.life/post/gianni_ciolli/ https://www.rubberduckdevshow.com/episodes/32-r