Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5

PostgreSQL Reviews & Product Details - Page 41

PostgreSQL Overview

What is PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL Details
Show LessShow More
Product Description
PostgreSQL is a powerful, open source object-relational database system.

Seller
Description

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:
008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

Overview Provided by:
CTO at Coronys LTD.

PostgreSQL Integrations

(3)
Integration information sourced from real user reviews.

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Product Avatar Image

Have you used PostgreSQL before?

Answer a few questions to help the PostgreSQL community

638 PostgreSQL Reviews

The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
638 PostgreSQL Reviews
4.4 out of 5
638 PostgreSQL Reviews
4.4 out of 5

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
soma s.
SS
Trainee
Computer Software
Mid-Market (51-1000 emp.)
"Best Database Server"
What do you like best about PostgreSQL?

The best thing about this database is, it is open source. We can customize it according to our requirements. Postgres is portable with all the platforms and programming languages. It does not requires more command line configurations. It is most reliable and stable database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There are some problems with postgres when we compared it to the mysql database. Low budget hosting sites supports mysql than postgres mostly. In terms of speed, mysql needs less work than the postgres. Also more open sources support mysql but not postgres. These are some of the problems with postgres. Review collected by and hosted on G2.com.

Verified User in Retail
AR
Enterprise (> 1000 emp.)
"Very Fast"
What do you like best about PostgreSQL?

Made for In Memory Computation. Works quite well and inexpensive. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Only good for analytic workloads. Scaling is an issue sometimes, but AWS has made it a breeze Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Small-Business (50 or fewer emp.)
"A simple SQL database"
What do you like best about PostgreSQL?

The ease of use, configure and manage. Postgres is a database solution for simple and medium complexity apps. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The app for manage, so I use other generic apps for manage SQL databases, like dBeaver Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Mid-Market (51-1000 emp.)
"Nice and free"
What do you like best about PostgreSQL?

Best free sql db out there. Reasonably easy to manage, quick. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Don't really have many complaints about the system, security could be better. Review collected by and hosted on G2.com.

Amit G.
AG
Senior Oracle DBA
Information Technology and Services
Enterprise (> 1000 emp.)
"Another open sourse RDBMS "
What do you like best about PostgreSQL?

Good for simple non critical applicatins, does what says on the tin. replciation backup and recovery is fantastic,. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Documentation and community support should improve, lack of support and help if you are stuck. Review collected by and hosted on G2.com.

Yaniro B.
YB
Bitcoin Crypto Currency Trader
Small-Business (50 or fewer emp.)
"PostgreSQL review"
What do you like best about PostgreSQL?

Although the speed of response may seem deficient in small databases, that speed is maintained by increasing the size of the database, which is not the case with other programs, which slow down brutally.

Unlimited installation: You can not sue a company for installing it on more computers than the license allows, as there is no cost associated with the software license. This allows for a more profitable business with large scale installations, we should not worry about being audited to see if we comply with the license, and there is flexibility and development without additional licensing costs.

Considerable savings in operating costs: PostgreSQL has been designed to have lower maintenance and adjustment than products of commercial suppliers, retaining all the features, stability and performance.

Stability and Reliability: No database crashes.

Extensible: The source code is available for free, so that whoever needs to extend or customize the program can do so without costs.

Multiplatform: Available on almost any Unix, with 34 platforms in the latest stable version, plus a native version of Windows in test state.

Designed for high-volume environments: Using a row storage strategy called MVCC, it gets better response in large volumes. In addition, MVCC allows read-only accesses to continue reading consistent data while updating records, allowing hot backups

Graphic design and database management tools.

It supports the SQL92 / SQL99 standard and standard type data, clauses, functions, and extended commands of PostgreSQL.

It can operate on different platforms, including Linux, Windows, Unix, Solaris and MacOS X.

Good security system through the management of users, groups of users and passwords.

Great storage capacity.

Good scalability as it is able to adjust to the number of CPUs and the amount of memory available optimally, supporting a greater number of concurrent requests to the database correctly. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Compared to MySQL it is slower in insertions and updates because it has intersection headers that does not have MySQL.

Online support: There are official forums, but there is no obligatory help.

Consume more resources than MySQL.

The syntax of some of your commands or statements is not at all intuitive. Review collected by and hosted on G2.com.

Christian P.
CP
Web Developer
Computer Software
Small-Business (50 or fewer emp.)
"Perfect for large projects"
What do you like best about PostgreSQL?

Always number one being Open source. It’s also quite easy to transition from MySQL the learning curve it almost nonexistent. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The Admin tools aren’t that great. Can be a hassle to install on a windows machine. Review collected by and hosted on G2.com.

Verified User in Computer Software
CC
Small-Business (50 or fewer emp.)
"One of the best Hybrid database systems available"
What do you like best about PostgreSQL?

PostgreSQL gives you the power of traditional relational DBMS system as well as the Power of json present in NoSql databases. You can Keep your table in flexible form to accommodate any kind of data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is good only for small and medium scale application, When data volumes exceeds few millions it needs a expert engineer to manage it. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Small-Business (50 or fewer emp.)
"Flexible and powerful"
What do you like best about PostgreSQL?

It's a full on relational database with good tooling and an extensive community. Even better it's got built in support for json and array types and even has full-text search features. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It requires some care and feeding, and like all relational databases works best with well-structured data. Review collected by and hosted on G2.com.

Verified User in Financial Services
UF
Small-Business (50 or fewer emp.)
"Excellent OpenSource Database with impressive performance and scaling capabilities"
What do you like best about PostgreSQL?

Postgresql is open source, easy to setup, easy to replicate and backup. The "Select Distinct On" function really helps in seeking the right unique data from large data sets. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I would like to see better documentation about configuration parameters as well as optimization parameters that can be applied to the DB setup. Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
PostgreSQL