Robert Haas

VP, Chief Architect, Database Server at EnterpriseDB

About

Robert has been involved in the PostgreSQL project since 2008, first as a patch reviewer and committer and a later as a major developer. Prior to that, he was a PostgreSQL application developer for nearly ten years. Features he has worked on include parallelism (9.4-9.6), the replacement of System V shared memory with anonymous shared memory (for 9.3), read and write scalability improvements (for 9.2), index-only scans (with Heikki Linnakangas and Ibrar Ahmed, for 9.2), unlogged tables (for 9.1), and left join removal (for 9.0). He works at EnterpriseDB as Chief Database Architect for the Database Server.

Robert Haas has presented the following presentations

    Robert Haas Moving PostgreSQL Forward at PGConf US 2017 [PgConf.US]

    presented by Robert Haas


    video

    PostgreSQL has a reputation for developing features in a slow and methodical way, producing very high-quality work, but sometimes taking years before a particular feature reaches full maturity. Why does this happen? What impact does it have on PostgreSQL use and adoption? What would be required for the PostgreSQL development community to move faster?

    Robert Haas Next-Generation Parallel Query at PGConf US 2017 [PgConf.US]

    presented by Robert Haas


    video

    PostgreSQL 9.6 features a basic implementation of parallel query, but there's much more to be done. In this talk, I'll discuss new features and capabilities proposed for v10, such as dynamic shared memory allocation, Gather Merge, Parallel Index Scan, Parallel Bitmap Heap Scan, Parallel Hash Join, Parallel Append, and Partition-wise Join. I'll also offer a preview of further work that may be un...

    more

    Thu 30 2017 Internals
    Robert Haas Parallel Query In PostgreSQL at PGConf US 2016 [PgConf.US]

    presented by Robert Haas


    video

    I and others have been working on bringing parallel query for PostgreSQL for several years now, but PostgreSQL 9.6 is the first release expected to include a user-visible feature. And it's pretty cool. In this talk, I'll give an overview of the development of this feature, where we are now, and what the future might hold. I will discuss the overall architecture of parallelism in PostgreSQL, giv...

    more

    Internals
    Robert Haas The Elephants In The Room: Limitations of the PostgreSQL Core Technology at PGConf US 2015 [PgConf.US]

    presented by Robert Haas

    The core architecture of PostgreSQL is significantly different from that of competing products like Oracle, SQL Server, or MySQL, which also differ from each other. Some of PostgreSQL's distinctive features, such as our highly extensible systems for adding new data types and new foreign data wrappers, have been tremendously successful in propelling PostgreSQL forward. Others, such as our storag...

    more

    Performance
    Robert Haas Partitioning Improvements in PostgreSQL 11 at PostgresConf US 2018
    Hash partitioning, CREATE INDEX, performance improvements, and more

    presented by Robert Haas

    PostgreSQL 10 was the first release to feature built-in declarative partitioning. While this feature offered significant performance and ease-of-use benefits as compared with previous releases, it left out numerous user-visible features and performance optimizations. PostgreSQL 11 is expected to offer significant further improvements to the table partitioning feature. These include both ...

    more

    Postgres Internals