Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
View analytic
Wednesday, September 28 • 4:00pm - 4:45pm
Scaling PostgreSQL Queries with Stado

Sign up or log in to save this to your schedule and see who's attending!

Stado, formerly know as GridSQL, provides a powerful and flexible analytical environment allowing users to process large amounts of data using a shared-nothing, massively parallel processing (MPP) architecture with PostgreSQL and PostGIS. Data is automatically partitioned across multiple nodes and each node processes its subset of data allowing queries to be distributed across the cluster and run in parallel. This fully open source architecture allows database performance to scale linearly as servers are added to the cluster while appearing as a single database to applications.

This presentation will demonstrate the 10-20x scalability and performance gains of PostgreSQL queries running in a Stado environment compared to a single PostgreSQL instance. Some intensive PostGIS queries will be the basis for the discussion. We will dig into how Stado plans a query capable of spanning multiple PostgreSQL servers and executes across those nodes using the Tiger data set as an example.

 


Speakers

Wednesday September 28, 2011 4:00pm - 4:45pm
B2 San Jose Convention Center

Attendees (6)