Poor Man's Parallel Processing

Check out http://www.pgconf.us/2015/event/63/ for the full talk details. 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 About the Speaker Corey Huinker is a database programmer and consultant. He specializes in database and query optimization and ETLs. His first database project was implementing language specific TPC-C benchmarks on a AS/400, where he was surprised to learn that RPG was faster than C. He is based in New York City. His past hobbies have included improvisational theater and refereeing roller derby.
Length: 39:35
Views 224 Likes: 0
Recorded on 2015-03-25 at PGConf US
Look for other videos at PGConf US.
Tweet this video