20240518 - VixulCon 2024 - The Rise of PostgreSQL_ Historic Trends and Modern Applications.pdf

Discover the journey of PostgreSQL from its origins at UC Berkeley to its status as the world’s most favored open-source database. This presentation will explore significant historical shifts towards open-source software in enterprise settings and PostgreSQL’s continuous evolution to meet changing technological standards. We will highlight its extensive feature set, accommodating a variety of use cases such as GIS, full text search, JSON, graph, time series, business intelligence, and vector storage. Additionally, we will examine why PostgreSQL’s versatility is highly valued by developers, offering ease of development along with improved performance and scalability.

1. The Rise of PostgreSQL
Historic Trends and Modern Applications
VixulCon | 18-May-2024

2. postgres=# select * from umair;

-[ RECORD 1 ]-----------------------------
name | Umair Shahid
description | 20+ year PostgreSQL veteran
company | Stormatics
designation | Founder
location | Islamabad, Pakistan
family | Mom, Wife & 2 kids
kid1 | Son, 17 year old
kid2 | Daughter, 14 year old

3. Our mission is to help businesses scale
PostgreSQL reliably for critical data

4. On to the topic now!

5. Introducing PostgreSQL
●Object-relational database
●Open source with a liberal license
●SQL Standard compliant
●ACID compliant (atomicity, consistency, isolation, durability)
●Supports structured as well unstructured data
●Highly extensible

6. A bit of a history lesson …
●1986 - The Berkeley POSTGRES Project
○Implementation started at University of California Berkeley
○Led by Professor Michael Stonebraker
○Sponsored by
■Defense Advanced Research Projects Agency
■Army Research Office
■National Science Foundation
■ESL, Inc
●1994 - Postgres95
○SQL interpreter added
○Code made open source
○30-50% faster than its predecessor
●1996 - PostgreSQL

7. The world’s most advanced open source relational database

9. Growth of Open Source Software
Estimated market size in 2022 - USD 25.6 billion
Expected market size in 2027 - USD 54.1 billion
16.2% Compound Annual Growth Rate
https://www.marketsandmarkets.com/Market-Reports/open-source-services-market-27852275.html

10. – Red Hat’s ‘The State of Enterprise Open Source 2022’
“The question is no longer whether your enterprise should
adopt open technologies; the question is when - and how.”
https://www.redhat.com/en/resources/state-of-enterprise-open-source-report-2022

11. Increasing levels of trust
https://www.redhat.com/en/resources/state-of-enterprise-open-source-report-2022

12. It is no longer just about cost …
https://www.redhat.com/en/resources/state-of-enterprise-open-source-report-2022

13. PostgreSQL
Oracle
Standard Edition
Oracle
Enterprise Edition
Database license $0 $17,500 $47,500
Clustering $0 Not Available $23,000
Partitioning $0 Not Available $11,500
Advanced Security $0 Not Available $15,000
Updates & Support $5,000 $3,850 $10,450
Total Cost $5,000 $21,350 $107,450
Cost Comparison (single socket only)

14. A glimpse of
PostgreSQL features …

15. ●Reliability
○Clustering & replication
○High availability
○Disaster recovery
●Scalability
○Horizontal + vertical
○Load balancing
○Connection pooling
●Performance
○Multiversion Concurrency Control
○Multiple index types
○Parallel query execution
●Security
○Data encryption
○Audit trail
○Multi factor authentication
PostgreSQL Features (not a comprehensive list)
●Extensibility
○Extensions for additional functionality
○Foreign data wrappers
○Language support for a variety of PLs
●Community
○Mailing lists, forums, social media groups
○Documentation, manuals, & tutorials
○Global and very diverse contributor base
●Vendor Support
○24/7 SLA-based support
○No vendor lock-in
○Zero licensing cost
●Compliance
○SQL Standard
○ACID Compliance
○Thought leadership in SQL Standard

16. PostgreSQL for everything!

17. Global brands using PostgreSQL in production

18. The world’s most advanced open source relational database

19. Questions?
pg_umair