SQL, Scaling, and What's Unique About PostgreSQL | XLDB Conference | Ozgun Erdogan

SQL, Scaling, and What's Unique About PostgreSQL | XLDB Conference | Ozgun Erdogan

Relational databases are known to have tightly integrated components that make them hard to extend. This usually leads to new databases that are specialized for scale and certain workloads.

For its last three releases, PostgreSQL has been providing official APIs to extend the database *without forking it*. Users can read the documentation, implement their ideas according to the APIs, and then dynamically load in their shared object to override or extend any database submodule.

In this talk, we will demonstrate four example APIs that make PostgreSQL a distributed database that focuses on real-time workloads:

1. PostGIS turns Postgres into a spatial database. It adds support for geographic objects, allowing location queries to be run in SQL. 2. JSON and JSONB enable storing and querying semi-structured data. 3. HyperLogLog & TopN add approximation algorithms to Postgres. These sketch algorithms are used in distributed systems when real-time responses to queries matter more than exact results. 4. Citus transforms Postgres into a distributed database. Citus transparently shards and replicates data, performs distributed deadlock detection, and parallelizes queries.

In summary, PostgreSQL's extensible architecture puts it in a unique place for scaling out SQL and also for adapting to evolving hardware trends. It could just be that the monolithic SQL database is dying. If so, long live Postgres!


Citus Data

May 01, 2018