Room: Ballroom A+B
Two recent additions to the PostgreSQL ecosystem have turned PostgreSQL into an attractive solution as a horizontally scalable document store. JSONB enables fast operations and indexing of JSON documents, while the pg_shard extension transparently shards PostgreSQL tables across many machines and replicates the shards for high availability. pg_shard also seamlessly distributes SQL statements, without requiring changes to the application layer.
In this talk we will discuss how to turn PostgreSQL into a scalable document store using pg_shard and JSONB. We will discuss different ways of sharding your data, the various performance trade-offs when sharding your data, and how to effectively combine JSONB with non-JSONB columns. We conclude with a futuristic demo: a distributed table with JSONB columns, backed by a dynamically changing row and columnar store.