Ranges, Partitioning and Limitations
Presented by:
Corey Huinker
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