Poor Man's Parallel Processing
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!
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 will be: - dblink - polymorphic functions and litations thereof - hijacking the COPY FROM PROGRAM command - JSON/HSTORE - parallel index rebuild
- Date:
- Duration:
- 30 min
- Room:
- Conference:
- PGConf US 2015 [PgConf.US]
- Language:
- Track:
- Performance
- Difficulty:
- Medium