Distributed PostgreSQL is a game changer Parikshit Savjani (@talktosavjani) Postgres Team at Microsoft

I work for I specialize in My current focus Parikshit Savjani @talktosavjani

Image by Simon Steinberger @talktosavjani PostgreSQL is more popular than ever

One of most loved and wanted databases in Stack Overflow’s 2019 Developer Survey https://insights.stackoverflow.com/survey/2019?utm_source=so-owned&utm_medium=blog&utm_campaign=dev-survey-2019&utm_content=launch-blog https://db-engines.com/en/blog_post/76 Ranked DBMS of the Year for 2 consecutive years by DB-Engines PostgreSQL is more popular than ever @talktosavjani

https://db-engines.com/en/ranking_trend/system/PostgreSQL PostgreSQL is more popular than ever 2013 2014 2015 2016 2017 2018 2019 2020 200 100 300 400 500 © February 2020, DB-Engines.com @talktosavjani

Why Postgres? Why Now? @talktosavjani

Why Postgres? Why Now? • Truly Open Source (No single owner) @talktosavjani

No content

Why Postgres? Why Now? • Truly Open Source (No single owner) • Feature rich & Highly Extensible @talktosavjani

Why Postgres? Why Now? • Truly Open Source (No single owner) • Feature rich & Highly Extensible • Robust, Reliable & Rich Ecosystem @talktosavjani

Why Postgres? Why Now? • Truly Open Source (No single owner) • Feature rich & Highly Extensible • Robust, Reliable & Rich Ecosystem • Speed of innovation and releases @talktosavjani

Why Postgres? Why Now? • Truly Open Source (No single owner) • Feature rich & Highly Extensible • Robust, Reliable & Rich Ecosystem • Speed of innovation and releases • Available as a service in all major clouds @talktosavjani

“Postgres is the new Linux of databases”- Unknown @talktosavjani

Common cloud native app patterns Multi-tenant SaaS applications @talktosavjani

Common cloud native app patterns Real time Operational Analytics @talktosavjani

Common cloud native app patterns Hybrid Transactional Analytical System @talktosavjani

Common cloud native app patterns Multi-tenant SaaS applications Real-time operational analytics Transactional/OLTP applications Massive data volume and processing needs @talktosavjani

Postgres Parallel Processing capabilities Postgres 9.6 Parallel Sequential scans, Joins and Aggregates Postgres 10 Parallel B-tree, bitmap heap scans, merge join, non-correlated sub queries. Postgres 11 Parallel Hash joins, DDL, Index Builds, Parallel partitions scans Postgres 12 Parallel Queries in Serializable Isolation Mode Postgres 13 Parallel Vacuum Credits: Amit Kapila (@kapila_amit) @talktosavjani

“Distributed PostgreSQL is the need of the hour” @talktosavjani

CITUS IS An Extension to Postgres @talktosavjani

Citus is Open Source @talktosavjani

Not a fork @talktosavjani

Citus shards Postgres database horizontally @talktosavjani

Distributed PostgreSQL scales better APPLICATION SELECT FROM GROUP BY company_id, avg(spend) AS avg_campaign_spend compaigns company_id; METADATA COORDINATOR NODE WORKER NODES W1 W2 W3 … Wn SELECT company_id sum(spend), count(spend) … FROM campaigns_2001 … SELECT company_id sum(spend), count(spend) … FROM campaigns_2009 … SELECT company_id sum(spend), count(spend) … FROM campaigns_2017 … @talktosavjani

A PERFORMANCE COMPARISON Distributing Postgres with Hyperscale (Citus) @talktosavjani

Microsoft Windows team relies on Citus and Postgres (on Azure) for mission-critical shiproom decisions Read more in our aka.ms/azure-postgres-blog: https://techcommunity.microsoft.com/t5/azure-database- for-postgresql/architecting-petabyte-scale-analytics-by- scaling-out-postgres-on/ba-p/969685 @talktosavjani

How do you manage distributed Citus cluster Your new best friend to manage distributed systems @talktosavjani

DEMO Deploying Citus cluster on Kubernetes @talktosavjani

Citus Azure Data Studio postgRest postgresql-hll pg_cron postgresql-topn pgloader @talktosavjani

CITUSDATA.COM/NEWSLETTER Do you get the Citus Newsletter? @talktosavjani

@tapoueh PGCONFINDIA ~ a 40% off discount on any edition Source: theartofpostgresql.com @talktosavjani

More popular than ever Distributed PostgreSQL = need of hour Citus shards Postgres & enables distributed processing Kubernetes = cluster management & portability Microsoft Postgres @talktosavjani

Distributed Postgres truly is changing the game. @talktosavjani

A good newsletter is like a good GIN index. Sign up for the Citus Newsletter @talktosavjani

@talktosavjani • @citusdata • @AzureDBPostgres ध"यवाद | Thank U AskAzureDBforPostgreSQL@service.microsoft.com