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

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.

Content Discussed

• How partial, covering, and multicolumn indexes may slow down UPDATEs in PostgreSQL
• TCP keepalive for a better PostgreSQL experience
• [YouTube] ElixirConf 2021 - Todd Resudek - I can do all things through Postgresql: Lessons for the Elixir dev
• Exploring PL/pgSQL: Strings, arrays, recursion, and parsing JSON
• Secure PostgreSQL 14 with CIS Benchmark
• Database Security Best Practices on Kubernetes
• Encrypting Postgres Data at Rest in Kubernetes
• Alexander Kukushkin
• Rubber Duck Dev Show Episode 18 | How Many 3rd Party Libraries Should You Use

YouTube Video

Podcast Audio