Parallelize and Scale PostgreSQL with GridSQL

Jim Mlodgenski

From East 2010 Speakers

Data is growing exponentially and businesses are demanding that IT pull relevant information out of these large datasets. PostgreSQL has difficulty in handling these complex queries on large databases since a session is limited to a single thread. GridSQL provides a fully open source layer to parallelize a query across many PostgreSQL instances allowing that query to leverage the full resources of a single server or scale horizontally to additional servers. In this session, the architecture of GridSQL will be discussed in detail as well as best practices for deploying a fully open source data warehouse using several PostgreSQL instances.