Corey Huinker

President at Corlogic

About

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.

Ranges, Partitioning, and Limitations

presented by Corey Huinker
Let's talk about range types, partitioning and its limitations including the great new Postgres v10 features.
Postgres
ETL Confessions

presented by Corey Huinker

video
ETL (Extract, Transform, Load) is the industry term for importing data from external sources into a database. However, more often the pattern is ELT - Extract, Load, Transform. This talk covers methods of loading external data into PostgreSQL and reshaping it to fit local needs. The talk addresses popular commercial tools, but focuses mostly on custom coding, specifically: *) Identifying bottle...
more
Development
Ranges, Partitioning and Limitations

presented by Corey Huinker
Range types are one of the things that truly sets PostgreSQL apart from other databases, but they are underused, and the functionality around them is not complete. This talk will go into some of those limitations (lack of a text range type, some missing operators etc) which the extension range_type_functions attempts to bridge. It will also cover the issues of using ranges as a partitioning mec...
more
Development
Poor Man's Parallel Processing

presented by Corey Huinker
Currently Postgres does not support transparent parallel query. Some third party tools implement parallel on a limited basis through proxies and sharding, but they also require building the entire database around that proxy. This talk will go into how one person (ab)used several features of Postgres and its extensions to achieve limited query parallezation on an existing database. Areas covered...
more
Performance
Multi-level Partitioning in PostgreSQL

presented by Corey Huinker
Many RDBMS products offer table partitioning to some limited degree. The number of layers of partitions may be limited to one or two columns, and there may be limited options for partitioning strategy in the second layer (i.e. hash only). PostgreSQL's roll-your-own partitioning creates considerable work for the programmer, but also allows for flexibility in that strategy: asymmetrical partition...
more
Admin
A Roadmap to Continuous Materialized Views
The benefits of continuously updated materialized views and the challenges for in implementing them
presented by Corey Huinker
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 postgre...
more
Fri 20 2018 Postgres Internals