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.

PGConf Silicon Valley PostgreSQL Conference Call for Speaker Proposals Closes June 15th

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:

  • Josh Berkus, PostgreSQL Experts
  • Peter van Hardenberg, Heroku
  • Albert Strasheim, CloudFlare
  • Simon Riggs, 2nd Quadrant
  • Elein Mustain, Adobe
  • Bruce Momjian, EnterpriseDB
  • Patrick King, Pandora Internet Radio
  • Ozgun Erdogan, Citus Data
  • Rafael Solari, Neustar
  • Aaron Brashears, Twitch

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.

What

PGConf Silicon Valley

Where

November 17–18, 2015

When

South San Francisco Conference Center
255 S Airport Blvd
South San Francisco, CA 94080
(map)

Call for Speakers Deadline

June 15, 2015

Page 1 of 18