About

Hannu has been working with PostgreSQL since it was called Postgres95 (and also played around with Postgres 4.2 - without the "SQL" - a little before that). His oldest surviving post on postgresql-hackers@ mailing list archives is from January 1998, proposing using index for fast ORDER BY queries with LIMIT.

Hannu was the first DBA at Skype, where he wrote patches for making VACUUM able to work on more than one table in parallel and invented the sharding and remote call language pl/proxy to make it easy to use PostgreSQL in an infinitely scalable way. During that time he also participated in design of other enterprise features like CREATE INDEX CONCURRENTLY, PARTITIONED TABLES and anything else that was required to run PostgreSQL 24/7.

After Skype he did 10+ years of PostgreSQL consulting all over the world as part of 2ndQuadrant.

For last three years he has been a PostgreSQL Database Engineer at Google working mostly with Cloud SQL.

---

Hannu Krosing has presented the following presentations

Do you vacuum everyday ? at Silicon Valley 2022

presented by Hannu Krosing
Postgresql has an amazing MVCC architecture. But it falls over in a small number of well-known cases (and a new one we recently found with temp tables). I have been a happy PostgreSQL user since 1995, and it was possible to run global-scale databases with the MVCC limitations - if you really knew how it works - at least since 2004/5 when we built the Skype database backend on PostgreSQL and s...
more
Thu 7 2022 Ops