Better Materialized Views in 1 Million LOC: Inside Materialize's PostgresSQL Source

PostgreSQL's materialized views are a great tool to provide low-latency answers to complex queries – but did you know they could offer serializable consistency if you used cutting-edge streaming engines, many millions of dollars, and countless hours of work from talented systems engineers and academics? Oh, and I guess you could then also join them with arbitrarily complex queries over Kafka topics…

In this talk, we'll take a look at what Materialize does from a few different points of views: how it differs from PostgreSQL, and how that fits into the modern data landscape. We'll then explore the architectural considerations we made to bring PostgreSQL data into an operational data warehouse. Lastly, we'll dive into the implementation details and the first correctness bug any of us have ever uncovered in PG.

Speaker and Presenter Information

Sean Loiselle, Member of Technical Staff, Materialize

Sean is a member of technical staff at Materialize. He's worked extensively on the PostgreSQL source, as well as all layers of our SQL engine.

Relevant Government Agencies

Air Force, Army, Navy & Marine Corps, Intelligence Agencies, DOD & Military, Office of the President (includes OMB), Dept of Agriculture, Dept of Commerce, Dept of Education, Dept of Energy, Dept of Health & Human Services, Dept of Homeland Security, Dept of Housing & Urban Development, Dept of the Interior, Dept of Justice, Dept of Labor, Dept of State, Dept of Transportation, Dept of Treasury, Dept of Veterans Affairs, EPA, GSA, USPS, SSA, NASA, Other Federal Agencies, Legislative Agencies (GAO, GPO, LOC, etc.), Judicial Branch Agencies, State Government, County Government, City Government, Municipal Government, CIA, FEMA, Office of Personnel Management, Coast Guard, National Institutes of Health, FAA, Census Bureau, USAID, National Guard Association, EEOC, Federal Government, State & Local Government, FDA, Foreign Governments/Agencies, NSA, FCC