Scaling Postgres Episode 100 Full Text Search | Query Optimization | Exception Blocks | Procedural Language
Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss full text search, a process for query optimization, caution with exception blocks and adding a procedural language.
Content Discussed
- [YouTube] "The State of (Full) Text Search in PostgreSQL 12" by Jimmy Angelakos
- The State of (Full) Text Search in PostgreSQL 12
- Introduction to Profiling and Optimizing SQL Queries for Software Engineers
- The strange case of the EXCEPTION block
- PL/PgSQL Exception and XIDs
- Creating a PostgreSQL procedural language – Part 1 – Setup
- An Overview of Job Scheduling Tools for PostgreSQL
- Can PgBouncer session survive everything we throw at it?
- How To Migrate From Trigger-Based Partitioning To Native in PostgreSQL
- Guard Against Transaction Loss with PostgreSQL Synchronous Replication
- [YouTube] Oracle to Postgres Schema Migration Hustle
- How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)
- How to run a clustering algorithm within PostgreSQL
- New in pg12: New leader_pid column in pg_stat_activity
YouTube Video
