May 2, 2025 · Databases

Scaling DaVinci Resolve’s Database to Millions of Projects: Evolution and Lessons

The article details how DaVinci Resolve’s project library, built on PostgreSQL, evolved from a monolithic server to a Docker‑based setup and finally to a Pigsty‑powered high‑availability cluster, covering challenges, point‑in‑time recovery, permission management, a real‑world outage, and the resulting reliability gains.

DaVinci ResolveDatabase MigrationHigh Availability

0 likes · 6 min read

Scaling DaVinci Resolve’s Database to Millions of Projects: Evolution and Lessons

IT Services Circle

Dec 5, 2024 · Databases

Understanding High-Concurrency Connection Issues in PostgreSQL and the Benefits of Using pgBouncer

The article explains how thousands of simultaneous client connections to a single PostgreSQL primary can cause severe write‑performance degradation, how introducing a connection pool such as pgBouncer reduces active backend processes dramatically, and why external pooling is preferred over built‑in solutions, illustrated with real‑world examples and a reference to the open‑source Pigsty distribution.

Connection PoolingDatabase ArchitecturePigsty

0 likes · 7 min read

Understanding High-Concurrency Connection Issues in PostgreSQL and the Benefits of Using pgBouncer