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-reviewing-owasp-top-5/