In this episode of Scaling Postgres, we discuss optimizing trigram searches, a review of Postgres replication, improvements to logical replication and a significant Timescale investment.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://alexklibisz.com/2022/02/18/optimizing-postgres-trigram-search.html
- https://pganalyze.com/blog/5mins-postgres-optimizing-postgres-text-search-trigrams-gist-indexes
- https://www.enterprisedb.com/blog/replication-revue
- https://www.percona.com/blog/logical-replication-decoding-improvements-in-postgresql-13-and-14/
- https://www.timescale.com/blog/year-of-the-tiger-110-million-to-build-the-future-of-data-for-developers-worldwide/
- https://www.shayon.dev/post/2022/47/pg-osc-zero-downtime-schema-changes-in-postgresql/
- https://www.cybertec-postgresql.com/en/monitoring-google-cloud-postgresql-with-pgwatch2/
- https://postgresql.verite.pro/blog/2022/02/21/psql-hack-select-except.html
- https://postgresql.life/post/julia_gugel/
- https://www.rubberduckdevshow.com/episodes/31-how-to-learn-a-new-code-base/