Scaling Postgres

In this episode of Scaling Postgres, we discuss tuning max connections, different SQL tricks, setting up fast text search and handling security & compliance. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/tuning-max_connections-in-postgresql/ https://towardsdatascience.com/6-sql-tricks-every-data-scientist-should-know-f84be499aea5 https://www.percona.com/blog/2020/04/16/sql-optimizations-in-postgresql-in-vs-exists-vs-any-all-vs-join/ https://pganalyze.com/blog/full-text-search-ruby-rails-postgres https://www.youtube.com/watch?v=cAbfHT5ed9g https://www.depesz.com/2020/04/17/waiting-for-postgresql-13-add-logical-replication-support-to-replicate-into-partitioned-tables/ https://www.highgo.ca/2020/04/18/the-origin-in-postgresql-logical-decoding/ https://www.highgo.ca/2020/04/17/replicate-multiple-postgresql-servers-to-a-single-mongodb-server-using-logical-decoding-output-plugin/ https://www.cybertec-postgresql