Scaling Postgres Episode 100 Full Text Search | Query Optimization | Exception Blocks | Procedural Language

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