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.