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

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.youtube.com/watch?v=c8IrUHV70KQ">https://www.youtube.com/watch?v=c8IrUHV70KQ</a></p> <p><a href= "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://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</a></p> <p><a href= "https://medium.com/scopedev/introduction-to-profiling-and-optimizing-sql-queries-for-software-engineers-3cf376ecc712"> https://medium.com/scopedev/introduction-to-profiling-and-optimizing-sql-queries-for-software-engineers-3cf376ecc712</a></p> <p><a href= "https://pgdba.org/post/2020/02/exception_block/">https://pgdba.org/post/2020/02/exception_block/</a></p> <p><a href= "https://fluca1978.github.io/2020/02/05/PLPGSQLExceptions.html">https://fluca1978.github.io/2020/02/05/PLPGSQLExceptions.html</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-1-setup/"> https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-1-setup/</a></p> <p><a href= "https://severalnines.com/database-blog/overview-job-scheduling-tools-postgresql"> https://severalnines.com/database-blog/overview-job-scheduling-tools-postgresql</a></p> <p><a href= "https://www.enterprisedb.com/blog/can-pgbouncer-session-survive-everything-we-throw-it"> https://www.enterprisedb.com/blog/can-pgbouncer-session-survive-everything-we-throw-it</a></p> <p><a href= "https://info.crunchydata.com/blog/how-to-migrate-from-tri