Max Connections, SQL Tricks, Fast Text Search, Security & Compliance | Scaling Postgres 110
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.com/en/intersecting-gps-tracks-to-identify-infected-individuals/
https://postgresql.life/post/ilaria_battiston/
https://www.depesz.com/2020/04/17/waiting-for-postgresql-13-allow-autovacuum-to-log-wal-usage-statistics/
https://www.depesz.com/2020/04/17/waiting-for-postgresql-13-add-the-option-to-report-wal-usage-in-explain-and-auto_explain/
Create your
podcast in
minutes
It is Free