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!

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 mechanism, which presents challenges significantly different than the more common time-series and fixed-single-value partitioning schemes. Examples will center around the range_partitioning extension.

Date:
Duration:
30 min
Room:
Conference:
PGConf US 2016 [PgConf.US]
Language:
Track:
Development
Difficulty:
Medium