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.
PGConf Silicon Valley is a technical conference for the PostgreSQL community scheduled for November 17th and 18th 2015 at the South San Francisco Conference Center. The call for speaking proposals for PGConf Silicon Valley is open until June 15, 2015.
We are pleased to welcome our distinguished Conference Committee which includes PostgreSQL community leaders from throughout the United States:
The conference will bring together the PostgreSQL community for an event filled with learning, connection building, and speakers from leading Postgres users and vendors on topics such as performance tuning, backup and replication, and new technologies.
PGConf Silicon Valley is the first solely PostgreSQL-focused conference in Silicon Valley. Sponsorship opportunities are available. Visit the PGConf Silicon Valley website to register or get more information about the conference.
PGConf Silicon Valley
November 17–18, 2015
South San Francisco Conference Center 255 S Airport Blvd South San Francisco, CA 94080 (map)
June 15, 2015