Search

Home > Scaling Postgres > Episode 110 Max Connections | SQL Tricks | Fast Text Search | Security & Compliance
Podcast: Scaling Postgres
Episode:

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

Category: Technology
Duration: 00:13:34
Publish Date: 2020-04-20 00:01:28
Description:

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/

 

Total Play: 0