Unconventional PostgreSQL Optimizations

kept by eddie jan 21

The article details unconventional PostgreSQL optimization techniques like using constraint_exclusion, function-based indexes, virtual generated columns, and hash indexes for efficiency.

Show HN: PgDog – Scale Postgres without changing the app
PgDog is a PostgreSQL proxy that provides connection pooling, load balancing, and sharding without modifying application code; written in Rust, it handles thousands of connections and supports cross-shard queries.
also on PostgreSQL, #infrastructure, #open-source, #software-engineering, #developer-tools
Video Conferencing with Postgres — PlanetScale
A developer demonstrates live video calls over PostgreSQL using logical replication, achieving 15fps with a $5 database.
also on PostgreSQL, #infrastructure, #software-engineering, #developer-tools