Presented by:

Corey huinker moat

Corey Huinker

Corlogic

Corey Huinker is a database programmer and consultant based in New York City. He specializes in database query optimization and ETLs.

He is the author of the PGXN modules Poor Mans Parallel Processing and range_partitioning.

His past hobbies have included improvisational theater and refereeing roller derby.

No video of the event yet, sorry!
Download the Slides

Materialized Views are an important tool for capturing complex query information in a way that can save time for subsequent queries. However, materialized views have important limitations in terms of maintenance and updatability. This presentation shows current workarounds for those issues and presents a path forward toward implementing continuously updating materialized views in native postgres, and potential benefits thereof.

Date:
2018 April 20 12:50 EDT
Duration:
50 min
Room:
Freedom
Conference:
PostgresConf US 2018
Language:
English
Track:
Postgres Internals
Difficulty:
Hard