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 presents 1 Event:

• Do you vacuum everyday ? at Silicon Valley 2022