Episode 110 Max Connections | SQL Tricks | Fast Text Search | Security & Compliance

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