Scaling PostgreSQL with GridSQL

Date: 2010-10-20
Location: New York, NY, United States

Location:

The Millburn Corporation

1270 Avenue of the Americas (at 50th and 6th)

Suite 1100

New York, NY 10001

212.332.7124

See http://www.meetup.com/postgresql-3/ to RSVP

GridSQL is sometimes mistakenly thought of as a replication solution along the likes of Slony and Bucardo, but the open source GridSQL project actually allows PostgreSQL queries to be parallelized across many servers allowing performance to scale nearly linearly. In this session, we will discuss the advantages to using GridSQL for large multi-terabyte data warehouses and how to design your PostgreSQL schemas and queries to leverage GridSQL. We will dig into how GridSQL plans a query capable of spanning multiple PostgreSQL servers and executes across those nodes. Some gotchas such as cross node joins will also be discussed.

Presented by Jim Mlodgenski

This event has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.

Note: The PostgreSQL Global Development Group does not endorse any events run by third parties. No guarantee of the quality of events is offered whatsoever.