Scaling Postgres

Index Downsides, TCP Keep Alive, Development with Postgres, Learning PL/pgSQL | Scaling Postgres 189

Informações:

Synopsis

In this episode of Scaling Postgres, we discuss the downsides of indexes, TCP keep alive options, developing with Postgres as your DB and learning PL/pgSQL. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://postgres.ai/blog/20211029-how-partial-and-covering-indexes-affect-update-performance-in-postgresql https://www.cybertec-postgresql.com/en/tcp-keepalive-for-a-better-postgresql-experience/ https://www.youtube.com/watch?v=mliO5_XhAKE https://notes.eatonphil.com/exploring-plpgsql.html https://blog.crunchydata.com/blog/secure-postgresql-14-with-the-cis-benchmark https://blog.crunchydata.com/blog/database-security-best-practices-on-kubernetes https://blog.crunchydata.com/blog/encrypting-postgres-data-at-rest-in-kubernetes https://postgresql.life/post/alexander_kukushkin/ https://www.rubberduckdevshow.com/episodes/18-how-many-3rd-party-libraries-should-you-use/