South Bay PostgreSQL Meetup

The 3rd South Bay PostgreSQL Meetup.

This is not a competitive event to the PG Meetups in SF, but rather aims to provide a platform for anyone in the South Bay who wants to avoid the traffic jams in SF.

We aim to host a Meetup every other month.

Pivotal will host this Meetup. You need to sign up for this Meetup. There is a maximum number of guests, sign up quickly.

If you are interested in presenting a Lightning Talk (5 min or less), please contact ascherbaum@pivotal.io with the details.

Speakers:

Ozgun Erdogan: pg_shard: Shard and scale out PostgreSQL

pg_shard is an open source sharding extension for PostgreSQL. It shards PostgreSQL tables for horizontal scale, and replicates them for high availability. The extension also seamlessly distributes SQL statements, without requiring any changes to the application layer.

pg_shard addresses many NoSQL use-cases, and becomes more powerful with the new JSONB data type. Further, the extension leverages the rich analytic capabilities in PostgreSQL, and enables real-time analytics for big data sets.

In this talk, we first summarize challenges in distributed systems associated with scaling out databases. We then describe "logical sharding", and discuss how it helps overcome these challenges. Next, we show how pg_shard uses hook APIs, such as the planner and executor hooks, to make PostgreSQL a powerful distributed database. We then cover example customer use-cases, and conclude with a live demo.

Peter Geoghegan: UPSERT in PostgreSQL

Peter Geoghegan, the primary author of the PostgreSQL "UPSERT" feature (INSERT ... ON CONFLICT DO UPDATE) discusses the syntax, uses, and design of the feature.

About Ozgun Erdogan

Ozgun is the CTO at Citus Data. Before Citus, Ozgun worked as a software developer in the Distributed Systems Engineering team at Amazon. There, he proposed, designed, and implemented novel algorithms on distributed caching and consistency; and also worked on building systems for scalable data analytics. Ozgun earned his M.S. in Computer Science from Stanford University, and holds patents on distributed consistency and load balancing.

About Peter Geoghegan

Peter has been involved in PostgreSQL development since 2011 as both a reviewer and feature implementer, and is a major contributor. His development projects tend to be centered on improving PostgreSQL's performance in various ways, including adding support for group commit, and, more recently, PostgreSQL 9.5's big improvements in text and numeric sort performance.

Originally from Dublin, Ireland, Peter now lives in San Francisco and works on Heroku's popular cloud database service.