Webinar on Parallelizing Analytical Queries in PostgreSQL on June 10th

Learn how to parallelize analytical queries in PostgreSQL through sharding. Join Marco Slot from Citus Data at 10:00 AM PDT on Wednesday, June 10, 2015 for a webinar which will discuss how to use parallel query execution to speed up queries for an analytical dashboard on a sharded PostgreSQL database, and the decisions that go into achieving optimal performance. You can register now by visiting the Citus Data Webinars page.

In this live webinar, we will discuss the need for sharding and parallel query execution to build an analytical dashboard for big data. You will learn about different schemes for sharding your tables, specifically range-partitioning and hash-partitioning, and their implications. We will show you how CitusDB plans and executes distributed queries on sharded tables to correctly and efficiently push down most of the computation to a cluster of worker nodes. Finally, we will discuss the pros and cons of using different sharding schemes in relation to parallel query performance and different data loading methods.

By the end of the webinar, attendees will have a greater understanding of the decisions that go into sharding a database and parallelizing analytical queries across a cluster as done by CitusDB and have a few important recommendations for picking a particular sharding scheme given your queries and data processing pipeline.

Visit the Citus Data Webinars page now to register.