Search

Home > Scaling Postgres > Episode 100 Full Text Search | Query Optimization | Exception Blocks | Procedural Language
Podcast: Scaling Postgres
Episode:

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

Category: Technology
Duration: 00:15:13
Publish Date: 2020-02-10 02:02:16
Description:

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-it

https://info.crunchydata.com/blog/how-to-migrate-from-trigger-based-partitioning-to-native-in-postgresql

https://info.crunchydata.com/blog/synchronous-replication-in-the-postgresql-operator-for-kubernetes-guarding-against-transactions-loss

https://www.youtube.com/watch?v=GtArnH1AuQM

https://www.2ndquadrant.com/en/blog/how-to-use-machine-learning-with-2uda-postgresql-and-orange/

https://www.cybertec-postgresql.com/en/how-to-run-a-clustering-algorithm-within-postgresql/

https://rjuju.github.io/postgresql/2020/02/06/new-in-pg13-leader_pid.html

 

Total Play: 0