postgres for the future

13
© 2014 EnterpriseDB Corporation. All rights reserved. 1 Postgres for the Future Marc Linster, SVP Products & Services

Upload: enterprisedb

Post on 11-May-2015

707 views

Category:

Internet


0 download

DESCRIPTION

The success of PostgreSQL supporting enterprise workloads has put the spotlight on where PostgreSQL development is headed next. Advances in recent releases have expanded the database’s ability to support new data types and unstructured data as data professionals wrestle with bigger and more complex data loads. Analysts are predicting a strong future for open source in the enterprise while companies are increasingly adopting open source into the data center to help control and reduce costs. Marc Linster, Senior Vice President of Products and Services at EnterpriseDB, will present his perspective on how PostgreSQL will continue to evolve to meet emerging new challenges in a world of Big Data and Cloud Computing.

TRANSCRIPT

Page 1: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 1

Postgres for the Future

• Marc Linster, SVP Products & Services

Page 2: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 2

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

Page 3: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 3

• 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

Page 4: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 4

Market forces influence direction

Easy to use / deployHigh-end Enterprise

Requirements

PostgreSQL is growing from the “middle-out”

New Workloads/Platforms (Big Data & cloud)

Page 5: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 5

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)

Page 6: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 6

• 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

Page 7: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 7

• 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

Page 8: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 8

• 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

Page 9: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 9

• 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

Page 10: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 10

• 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

Page 11: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 11

The Sky’s the Limit!

Page 12: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 12

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?

Page 13: Postgres for the Future

© 2014 EnterpriseDB Corporation. All rights reserved. 13