Álvaro Herrera

Álvaro Herrera is a PostgreSQL contributor and committer. He authored autovacuum, background workers, BRIN indexes, commit timestamps, savepoints, shared row locking, and some partitioning features. Álvaro co-authored DDL-event triggers, MERGE, XMLTABLE, \crosstabview. He also shepherded thousands of patches from other people into open source PostgreSQL.

Álvaro has more than 20 years of experience writing new PostgreSQL features and his code appears in all supported major releases and is used in millions of servers around the world.

Your database is corrupt? Álvaro can fix it.

Read Blogs

Technical Blog

Column Store Plans

Over at pgsql-general, Bráulio Bhavamitra asks: I wonder if there is any plans to move postgresql entirely to a columnar store (or at least make it an option), maybe for version 10? This is a pretty interesting question. Completely replacing the current row-based store wouldn’t be a good idea: it has served us extremely well and I’m pretty sure that replacing it entirely with a columnar store...
Technical Blog

9.6 Scariest Patch Tournament

PostgreSQL’s Release Management Team is requesting your input on patches that are most likely to cause bugs or instability. I’m sure you have an opinion on that! Please cast your votes by filling this form.
Technical Blog

Code coverage stats

Many years ago, Michelle Caise submitted a patch to generate code coverage reports for the PostgreSQL code base, based on the lcov utility. Although I cannot find any record of an actual patch in the mailing list archives, Peter Eisentraut committed it some time later, and applied further refinements later. Today I’m announcing a new PostgreSQL community service: code coverage reports generated...
Technical Blog

Managing a PostgreSQL Commitfest

If you’ve been following PostgreSQL development for the last few years, you’ve probably heard the term commitfest manager a few times. You probably already know what a commitfest is, but why is there a manager? Since I spent a good deal of time this past January managing one, I’ll explain. Patch applied during commitfest At its heart, a PostgreSQL commitfest is just a collection of patches...