Scaling Postgres Episode 223 Database Decomposition, Fast Text Search, Understanding pg_stat_activity, Window Functions
In this episode of Scaling Postgres, we discuss the process of decomposing your database, how to search text in Postgres quickly, how to understand the output of pg_stat_activity and how to use window functions to solve a use case.