IBM DB2 vs PostgreSQL

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

IBM DB2
IBM DB2

81
60
+ 1
15
PostgreSQL
PostgreSQL

17.5K
13.3K
+ 1
3.4K
Add tool

IBM DB2 vs PostgreSQL: What are the differences?

What is IBM DB2? A family of database server products developed by IBM. DB2 for Linux, UNIX, and Windows is optimized to deliver industry-leading performance across multiple workloads, while lowering administration, storage, development, and server costs.

What is PostgreSQL? A powerful, open source object-relational database system. PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

IBM DB2 and PostgreSQL belong to "Databases" category of the tech stack.

"Rock solid and very scalable" is the top reason why over 5 developers like IBM DB2, while over 744 developers mention "Relational database" as the leading cause for choosing PostgreSQL.

PostgreSQL is an open source tool with 5.38K GitHub stars and 1.79K GitHub forks. Here's a link to PostgreSQL's open source repository on GitHub.

reddit, Instacart, and StackShare are some of the popular companies that use PostgreSQL, whereas IBM DB2 is used by XMLi5 Ltd., ITAIPU BINACIONAL, and Applic8. PostgreSQL has a broader approval, being mentioned in 2701 company stacks & 2097 developers stacks; compared to IBM DB2, which is listed in 7 company stacks and 9 developer stacks.

- No public GitHub repository available -

What is IBM DB2?

DB2 for Linux, UNIX, and Windows is optimized to deliver industry-leading performance across multiple workloads, while lowering administration, storage, development, and server costs.

What is PostgreSQL?

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose IBM DB2?
Why do developers choose PostgreSQL?

Sign up to add, upvote and see more prosMake informed product decisions

    Be the first to leave a con
    What companies use IBM DB2?
    What companies use PostgreSQL?

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with IBM DB2?
    What tools integrate with PostgreSQL?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to IBM DB2 and PostgreSQL?
    Oracle
    Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
    MySQL
    The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
    MongoDB
    MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
    Microsoft SQL Server
    Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
    MariaDB
    Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
    See all alternatives
    Decisions about IBM DB2 and PostgreSQL
    Anton Sidelnikov
    Anton Sidelnikov
    Backend Developer at Beamery · | 6 upvotes · 9.2K views
    PostgreSQL
    PostgreSQL
    MongoDB
    MongoDB

    In my opinion PostgreSQL is totally over MongoDB - not only works with structured data & SQL & strict types, but also has excellent support for unstructured data as separate data type (you can store arbitrary JSONs - and they may be also queryable, depending on one of format's you may choose). Both writes & reads are much faster, then in Mongo. So you can get best on Document NoSQL & SQL in single database..

    Formal downside of PostgreSQL is clustering scalability. There's not simple way to build distributed a cluster. However, two points:

    1) You will need much more time before you need to actually scale due to PG's efficiency. And if you follow database-per-service pattern, maybe you won't need ever, cause dealing few billion records on single machine is an option for PG.

    2) When you need to - you do it in a way you need, including as a part of app's logic (e.g. sharding by key, or PG-based clustering solution with strict model), scalability will be very transparent, much more obvious than Mongo's "cluster just works (but then fails)" replication.

    See more
    Yonas Beshawred
    Yonas Beshawred
    CEO at StackShare · | 9 upvotes · 29.8K views
    atStackShareStackShare
    MemCachier
    MemCachier
    PostgreSQL
    PostgreSQL
    Rails
    Rails
    Amazon ElastiCache
    Amazon ElastiCache
    Heroku
    Heroku
    Memcached
    Memcached
    #Caching
    #RailsCaching

    We decided to use MemCachier as our Memcached provider because we were seeing some serious PostgreSQL performance issues with query-heavy pages on the site. We use MemCachier for all Rails caching and pretty aggressively too for the logged out experience (fully cached pages for the most part). We really need to move to Amazon ElastiCache as soon as possible so we can stop paying so much. The only reason we're not moving is because there are some restrictions on the network side due to our main app being hosted on Heroku.

    #Caching #RailsCaching

    See more
    John Kodumal
    John Kodumal
    CTO at LaunchDarkly · | 15 upvotes · 191K views
    atLaunchDarklyLaunchDarkly
    Amazon RDS
    Amazon RDS
    PostgreSQL
    PostgreSQL
    TimescaleDB
    TimescaleDB
    Patroni
    Patroni
    Consul
    Consul
    Amazon ElastiCache
    Amazon ElastiCache
    Amazon EC2
    Amazon EC2
    Redis
    Redis