Download - Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 1

Postgres for the Future

• Marc Linster, SVP Products & Services


The PostgreSQL Journey…

SQL Standards Enterprise Features / Ease of UseStability

19961998

20012013

???

• Enterprise Features

− Streaming Replication

− Performance

− Vertical Scale

− PITR

− pg_upgrade

• Ease of Use

− Windows Port

− Graphical Installers

− pg_basebackup

− Tools--Courtesy Bruce Momjian

• Basic Functionality

− JDBC

− MVCC

− Optimizer Stats

− PL/pgSQL

• Stability

− Fixing Crashes

− Cleaning up code

− Culture of perfection

• Standards

− SQL 92 Joins

− Prepared queries

− Foreign Keys

• Core Functionality

− Write Ahead Log

− Prepared Queries

− Info. Schema

− Auto Vacuum


• Enterprise features without the cost

• Wider range of performance than MySQL & others

• More pluggable than any other database:− Backend languages, Index Types and FDWs

− Opportunity to connect with emerging technologies

• Best Geo-Spatial implementation

Postgres is well positioned now

• Legendary stability

• Serializable Snapshot Isolation

• Strong, independent, thriving community


Market forces influence direction

Easy to use / deployHigh-end Enterprise

Requirements

PostgreSQL is growing from the “middle-out”

New Workloads/Platforms (Big Data & cloud)


The Next 5 Years??

• Diagnosing Problems

• Configuring for success

• Still easier installs

• Tighter integration with frameworks

• Very simple in the cloud

• Vertical Scale (parallel query)

• Horizontal Scale

• Performance Diagnostics

• Incremental Backup

• FDW for other data sources

• Zero down time upgrades

• Liasons with other communities

• FDW for common no-SQL DB’s

• Continue to evolve new datatypes: JSON, HStore, XML

Easy to use / deployHigh-end Enterprise

Requirements

New Workloads/Platforms (Big Data/Cloud)


• Cloud PaaS has the highest growth rate 35%+ (accoding to Gartner)

• EDB‘s Postgres Plus Cloud Database at AWS confirms this− Easy installation

− Elastic and scalable

− Automatic failover

Postgres: Cloud

Source: Gartner 2013 Forecast: Public Cloud Services, Worldwide, 2011-2017, 3Q13 Update


• JSON is the most popular data-interchange format on the web today

• Supported by virtually every programming language

• New supporting technologies (also supported by Postgres) continue to expand JSON’s utility− PL/V8 JavaScript extension

− PL/Coffee V8 extension

− Node.js

• Postgres has a native JSON data type (v9.2) and a JSON parser and a variety of JSON functions (v9.3)

• Postgres will have a JSONB data type with binary storage and indexing (coming – v9.4)

Postgres: Document Store


• Supported since 2006, the HStore contrib module enables storing key/value pairs within a single column

• Allows you to create a schema-less, ACID compliant key value store within Postgres

Postgres: Key-value Store

•Combines flexibility with ACID compliance

• Create single HStore column and include, for each row, only those keys which pertain to the record

• Add attributes to a table and query without advance planning


• The spirit of open source community has led to the development of Foreign Data Wrappers

• Foreign Data Wrappers (SQL MED) allow queries to read and write data to foreign data sources.

• Foreign database support includes: − CouchD, Informix, MongoDB, MySQL

− Neo4j, Oracle, Postgres, Redis

Postgres: Database Federation


• Document store with ACID and relational capabilities

• Database federation; datacenter hub

• Cloud workhorse

• Decades-long track record of quality and stability

• TCO cost avoidance from new (unnecessary?) systems:− Operational support

− Duplicated storage

− Software upgrades

− Monitoring & management

− Hardware

− Training

− Additional staffing

• Say Yes to ‘NO SQL’ – use Postgres

Maximizing the Potential of Postgres


The Sky’s the Limit!


PostgreSQL

Postgres Plus Advanced Server Postgres Plus

Cloud

• 160+ employees; 2,500+ customers• Global presence: offices in USA, NL, UK, IN, and Japan• Focused on serving needs of enterprise, government and ISV markets• Strategic partnerships with Red Hat, IBM & HP• Fast growing: 60%+ YOY growth in 2012 & 2013

Who is EDB?

Download - Postgres for the Future

Top Related