Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.youtube.com/watch?v=c8IrUHV70KQ https://fosdem.org/2020/schedule/event/postgresql_the_state_of_full_text_search_in_postgresql_12/attachments/slides/4138/export/events/attachments/postgresql_the_state_of_full_text_search_in_postgresql_12/slides/4138/FTS.pdf https://medium.com/scopedev/introduction-to-profiling-and-optimizing-sql-queries-for-software-engineers-3cf376ecc712 https://pgdba.org/post/2020/02/exception_block/ https://fluca1978.github.io/2020/02/05/PLPGSQLExceptions.html https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-1-setup/ https://severalnines.com/database-blog/overview-job-scheduling-tools-postgresql https://www.enterprisedb.com/blog/can-pgbouncer-session-survive-everything-we-throw-i