Handle One Million Connections? | Scaling Postgres 360

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/360-handle-one-million-connections/

In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port 5432 and Postgres on Kubernetes.

Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Timestamps:
01:16 - PgDog
04:23 - pgdogdev / pgdog
05:13 - PgDog Site
05:21 - PgDog Dog
05:36 - Using pgvector for timeseries data
07:36 - Semantic Search in PostgreSQL: An Overview
07:57 - Do not expose port 5432 to the public Internet
09:13 - CNPG Recipe 17 - PostgreSQL In-Place Major Upgrades
11:15 - Postgres on Kubernetes for the Reluctant DBA
12:16 - PostgreSQL 18: “swap” mode for pg_upgrade
13:16 - pgstream v0.4.0: Postgres-to-Postgres replication, snapshots & transformations
13:57 - TIL - Starting in read-only mode the easy way
15:06 - Consultiing Corner
15:59 - Outro

#postgres #postgresql

Видео Handle One Million Connections? | Scaling Postgres 360 канала Scaling Postgres