Scaling PostgreSQL

How OpenAI scaled PostgreSQL to handle millions of queries per second for 800 million users. Through rigorous optimizations, connection pooling, caching strategies, and careful workload isolation, PostgreSQL powers ChatGPT with a single primary and nearly 50 read replicas across regions. » Bohan Zhang | openai.com

28 de febrero de 2026 · 1 min · 45 palabras · Nacho Cano

El misterio del consumo de CPU de PostgreSQL

Misterio resuelto: Alto consumo de CPU de PostgreSQL. Descubre cómo un simple ajuste del healthcheck en Docker fue la clave. ¡Optimiza Shuul y tu servidor! » atareao con Linux | atareao.es

28 de octubre de 2025 · 1 min · 31 palabras · Nacho Cano

Run Django tests using PostgreSQL in GitHub Actions

Did you know that you can run unit tests for your Django app, in GitHub Actions, using PostgreSQL? » Kevin Renskers | loopwerk.io

7 de octubre de 2025 · 1 min · 23 palabras · Nacho Cano

Django PostgreSQL Anonymizer

Django integration for PostgreSQL Anonymizer extension » Django Packages | djangopackages.org

6 de octubre de 2025 · 1 min · 11 palabras · Nacho Cano

Django Transactions & PostgreSQL Locks: Why Your Database is Slower Than You Think

This is the finale in a three-part series on how Django transactions work. I cover how PSQL locks work and map PSQL commands to their locks. » hackernoon.com | hackernoon.com

25 de marzo de 2025 · 1 min · 30 palabras · Nacho Cano

Deploying Django app with Docker, Docker-Compose and Certbot

Deploying a Django application using Docker Compose with Nginx, Gunicorn, PostgreSQL, and Certbot. » agiliq.com | agiliq.com

15 de noviembre de 2024 · 1 min · 17 palabras · Nacho Cano

An Overview of PostgreSQL indexing

PostgreSQL 16 brings some key improvements to indexing that, while technical, have a direct impact on performance. » hackernoon.com | hackernoon.com

27 de septiembre de 2024 · 1 min · 21 palabras · Nacho Cano

PostgreSQL Internals for Newbies: A Guide to Data Storage, Part One

Curious about what happens behind the scenes when creating a table in PostgreSQL? Our latest blog breaks it down, showing how PostgreSQL tracks your data with unique identifiers and where the data gets stored on disk » David Stokes | percona.com

6 de septiembre de 2024 · 1 min · 41 palabras · Nacho Cano

TestDriven.io: Approximate Counting in Django and Postgres

This article looks at how to speed up counting with Django and PostgreSQL. » testdriven.io | testdriven.io

6 de junio de 2024 · 1 min · 17 palabras · Nacho Cano

A Brief History of Logical Replication in Postgres

Postgres logical replication has evolved over the years. Understand the impact of these changes on your distributed Postgres future. » pgedge.com | pgedge.com

26 de enero de 2024 · 1 min · 23 palabras · Nacho Cano