1 / 57

Comparing PostgreSQL to Oracle The best kept secret to success

Comparing PostgreSQL to Oracle The best kept secret to success. Tim Steward: Sales Engineer timothy.steward@enterprisedb.com. Agenda. Introduction Comparing Technologies Eliminate the Confusion Some words on pricing Getting Started Questions / Conclusion. My Passport.

dfaust
Download Presentation

Comparing PostgreSQL to Oracle The best kept secret to success

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Comparing PostgreSQL to OracleThe best kept secret to success Tim Steward: Sales Engineer timothy.steward@enterprisedb.com

  2. Agenda Introduction Comparing Technologies Eliminate the Confusion Some words on pricing Getting Started Questions / Conclusion

  3. My Passport Oracle DBA road trip began in 1991 Resorts: 12c,11g,10g,9i,8i,7.x,6.x,5.x,3.x Resorts: EBS 10.6,10.7nca,R11,R12 Timeshares: Forms 3, 6, 9 Cabins: Sybase, Sql Server, Mysql, SAP Basis, Netsuite, Postgresql, Pentaho, Redshift, ServiceNow

  4. I installed from these methods!!

  5. WHO IS EDB? The world leader in open-source based Postgres software and services. • Founded in 2004 • Recognized RDBMS leader by: • Gartner • Forrester • Customer base > 4,000 • 300+ employees • Offices worldwide • Largest PostgreSQL community leader

  6. WORLDWIDE PRESENCE

  7. U.S Customers OVER 4,000 CUSTOMERS Running Postgres IN PRODUCTION 92 of the Fortune 500 311 of the Forbes Global 2000 Our customers benefit from the most reliable, high-performing, flexible, open, and cost-effective data management platform available. EMEA Customers APAC Customers

  8. EDB Postgres Platform

  9. EDB POSTGRES DATABASE COMPATIBILITY EDB PostgresAdvanced Server Security SECURITY TOOLS PERFORMANCE Tools PostgreSQL Performance Compatibility Advanced Server

  10. EDB Open Source GURUS MAJOR CONTRIBUTORS CORE TEAM CONTRIBUTORS • Andres Freund • Bruce Momjian DevrimGündüz • Akshay Joshi • AmulSul • AsheshVashi • Ashutosh Sharma • Dave Page • Robert Haas • Thomas Munro • Mithun Cy • M. Usama • Dilip Kumar • Jeevan Ladhe • Thom Brown • Rushabh Lathia • Amit Kapila Named EDB open source committers and contributors

  11. Disclaimer When I say Oracle I mean Oracle Enterprise Edition + options When I say PostgreSql I mean EnterpriseDB Advanced Server

  12. A Proven Track Record PostgreSQL PostgreSQL is the database management system that gained more popularity in the DB-Engines Ranking within the last year than any of the other 343 monitored systems. https://db-engines.com/en/blog_post/79 Most mature open source DBMS technology Strong, independent community PostgreSQL is the DBMS of the Year 2018 and 2017 – DB Engines

  13. COMPARING TECHNOLOGIES

  14. Besides some differencesthere area lot of similarities

  15. Both based on IBM research for System R.https://en.wikipedia.org/wiki/IBM_System_R Both are (+) relational databases ACID compliant and MVCC or transactional consistency Full transaction logging (REDO vs. WAL) Multi-Tenant architecture General / Capabilities

  16. Application Development General / Capabilities Management Capacities Tables and Partitioning Incompatibilities Deployment Options Terminology Data Types Indexes SQL Capabilities SQL Extensions Big / Unstructured Data Integration Security Performance / Scalability High Availability

  17. Postgres: A Proven Track Record Fully ACID Compliant MVCC Point in Time Recovery (PITR)‏ Data and Index Partitioning Bitmap Indexes ANSI Constraints Triggers & Stored Functions Views & Data Types Nested Transactions Online Backup Online Reorganization Foreign Keys Streaming Replication Multi-Core Support JSON SupportHStore Most mature open source DBMS technology Enterprise-class features (built like Oracle, DB2, SQL Server) Strong, independent community driving rapid innovation

  18. Terminology

  19. Postgres Possible but not advised: • Unlimited database size • Unlimited rows per table • Unlimited number of indexes per table

  20. Capacity

  21. Tables & Partitions

  22. Data Types

  23. Data Types/capabilities cont…

  24. Indexes

  25. SQL Capabilities

  26. SQL Extensions

  27. Eliminate the confusion

  28. Oracle has an isolated operating environment • Operating system like qualities • PostgreSQL integrates in it’s surroundings • Eliminating the need to “re-invent the wheel” Closed vs Open

  29. RAC vs MMR !!! Courtesy: Ben Stopford

  30. Real Application Cluster Courtesy: UweHesse Courtesy: ULX Hungary

  31. Multi Master Replication Include pgpool II Courtesy: ULX Hungary Courtesy: ULX Hungary

  32. Connection Confusion: • Oracle has a listener • Postgres has a postmaster • Oracle defaults 1521 • Postgres defaults 5432, 5444 • Oracle sqlnet.ora • Postgrespg_hba.conf

  33. Log Confusion: • Oracle has online redo logs • Postgres has wal logs (write ahead logging) • Oracle has log switch tuning • Postgres has file reuse tuning

  34. Tuning/Configuration/Memory Confusion: • Oracle has init.ora • Postgres has postgresql.conf • Oracle db_cache_size • Postgresshared_buffers • Oracle log_buffer_size • Postgreswal_buffers

  35. Permission Confusion: • Oracle has users and roles • Postgres has roles only • Oracle schema consist from a single user objects (schema = user) • Postgres schema is a grantable name-space object

  36. Additional Monitoring Tools PGadmin4 - default gui monitoring DBA Scripts : (pg_stat_statements, pg_stat_activity, pg_locks, pg_roles, pg_tables…)

  37. Toad Edge

  38. Where is the UNDO? Oracle stored in the datafiles Postgres stored in each table In postgresql this undo creates bloat BLOAT needs to be VACUUMED Bloat leads to bad performance…

  39. High Availability

  40. Performance & Scalability

  41. Security

  42. Security cont...

  43. Ease of Application Development

  44. Ease of Application Development cont.

  45. BIG DATA – Unstructured data !!!In the OS we trust…

  46. Integration

  47. Management !!!In the OS we trust…

  48. Database Setup 30 seconds 5 seconds 15 seconds 1 minute 30 seconds 30 seconds 30 seconds

  49. Database Setup

  50. Is it really that easy Installed and running in minutes!!

More Related