Yes, often more so.
PostgreSQL has been the fastest growing DBMS for the last 2 years in terms of market awareness, as listed on DBEngines.com, an independent market assessment service. PostgreSQL is now in 4th position, behind Oracle/MySQL and SQLServer, both of whom have significantly larger marketing budgets.
PostgreSQL has also placed very well in recent survey results from StackOverflow, who surveyed more than 60,000 developers.
Results from StackOverflow shown below, all rights acknowledged:
Does PostgreSQL support Replication? “out of the box”?
Yes, two kinds of replication are supported in the core PostgreSQL server.
Physical Replication is designed to provide High Availability. When used with the Hot Standby option, these “Read Replica” nodes can be used to execute a read-only workload. PostgreSQL supports multiple standby nodes, and these can be cascaded to create large clusters for query offload.
Logical Replication is designed to replicate changes from one or more tables in a set for application integration, or to replicate the whole server to facilitate major version upgrade.
Both of these options have significant open source contributions from 2ndQuadrant over more than a decade. These options are similar to, but not compatible with, Oracle Data Guard, which also supports replication to physical and logical standby nodes.
So Third Party packages are also required to make it work?
The open source community around PostgreSQL is similar to other Database Management Systems vendors in many ways. There is a core Database package and then additional tools and utilities are required to work together to produce a solution. The open source community differs in that the various projects aren’t all managed and licenced by a single monolithic entity. However, support companies like 2ndQuadrant, support all the tools required to build successful PostgreSQL solutions, offering a consistent technical architecture with a single point for Support and hot fixes of each component. There is no need to perform long evaluations of each component to integrate them to your own architecture.
Does PostgreSQL support Clustering “out of the box”?
PostgreSQL does not support Active-Active clustering in its core. This is provided by an extension known as BDR, authored and supported by 2ndQuadrant. Some of the largest users of Oracle Golden Gate have migrated to BDR in preference because of its ease of use and cost advantages.
PostgreSQL allows a full physical backup. Options for parallel and incremental backup are supported by 2ndQuadrant through the open source Barman utility. Just as with Oracle, multiple tools fit together into a full solution architecture.
What are the requirements for PostgreSQL PITR recovery?
PostgreSQL backup is based upon binary files, which can differ depending upon the hardware architecture of the server. It is recommended that you use the same OS/software/platform/config when recovering from backup, but some variations are possible, for example, different maintenance release versions will not cause any problems. File definitions can change between major software releases, so these cannot be used to upgrade the server; upgrade can be easily achieved using other mechanisms.
Does PostgreSQL perform as well as Oracle or SQLServer?
Many applications migrating from other databases report that they run much faster when running on PostgreSQL. It’s difficult to compare performance on Oracle because the software licence precludes users from discussing their performance results in public. High-end performance results can also be distorted because the TPC benchmarks have been heavily tuned to the exact workload after many years of tuning. PostgreSQL has never attempted this; instead PostgreSQL focuses heavily on real-world performance and fixing customer issues more directly. The latest release of PostgreSQL comfortably exceeds 1 million TPS on a read-only workload, measured on a meaty 4 socket server. Customers of 2ndQuadrant regularly report in excess of 1000 TPS in real-world read-write transaction workloads with synchronous replication.
Simon Riggs is the Founder and CTO of 2ndQuadrant. With more than 30 years of experience in the Database Technology industry, he is one of the few major developers to the open source PostgreSQL project having contributed in every release to date.
If you have a question, please fill out the form below. The most commonly asked questions will be answered here.