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 38

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.
John R.
JR
Co-founder, lead developer
Small-Business (50 or fewer emp.)
"By far the most powerful and advanced open source database software"
What do you like best about PostgreSQL?

The developer community behind Postgres is phenomenal. Not only do they keep the software active, they give their time speaking and teaching about the software. The speed and reliability of the software is also great. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres number one priority is data reliability, then speed, which causes some features like COUNT() to be slower than I'd like. While this is ideal 99% of the time, there is that 1% when I wish there was an option to configure the software to make COUNTs faster, even if it meant less reliability for that qeury's result. Review collected by and hosted on G2.com.

Juan M.
JM
Project Manager
Information Technology and Services
Small-Business (50 or fewer emp.)
"Relational database for professionals"
What do you like best about PostgreSQL?

PostgreSQL is the best open source relational database system. It is the most complete and it gives you the best performance and functionality. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is a bit complex at the beggining. There are a lot of options even in the query interface PgAdmin. You need a lot of database background to take it for Bussiness. Review collected by and hosted on G2.com.

JG
Mid-Market (51-1000 emp.)
"Easy database manager"
What do you like best about PostgreSQL?

Open source and free to use.

PostgreSQL allows you to make backups and exports of your databases very easily, what is very important if you wan t to keep your work safe. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When working with huge databases, PostgreSQL can be slow and sometimes it seems to be crashed, even though it's working. Review collected by and hosted on G2.com.

Verified User in Military
UM
Mid-Market (51-1000 emp.)
"Great Product, especially for small projects"
What do you like best about PostgreSQL?

Easy to spin up a simple database, free to start, open source community Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much, but the wrappers for Postgres can be somewhat complicated. Review collected by and hosted on G2.com.

Daniel R.
DR
Software Engineer Intern
Computer Software
Enterprise (> 1000 emp.)
"PostgreSQL used with Ruby on Rails"
What do you like best about PostgreSQL?

It packs all the features you need in a simple to use interface. It has several GUI tools and you can install it either in windows or UNIX OS. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

So far there is nothing I dislike. I haven't come up with any problems so far. Review collected by and hosted on G2.com.

AG
Software Engineer
Information Technology and Services
Enterprise (> 1000 emp.)
"Open source object-relational database management system for Web Developers"
What do you like best about PostgreSQL?

PostgreSQL or simply Postgres implements the SQL standard very well. Postgres provides a easy to understand tool called pgAdmin to interact and manipulate database. It provides support for complex data types like Array and Json. It can handle workloads ranging from small web applications to large data warehousing with many concurrent users. It is available till 10,000 rows on Heroku. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL query syntax for some complex queries like array,string functions and case operator are is not easy to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as MySQL and it is bit harder to google search results. Review collected by and hosted on G2.com.

Verified User in Government Administration
CG
Enterprise (> 1000 emp.)
"PostgreSQL MPP database review"
What do you like best about PostgreSQL?

Performance. This is the promise of a MPP and PostGreSQL lives up to its promise. Also frequent releases adds more and more features. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much. A little more UI tools would be useful. Also the provision to support more external tables will definitely help. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Mid-Market (51-1000 emp.)
"Review for Postgre"
What do you like best about PostgreSQL?

The interface and usability is very good Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is nothing that i don't like about this now Review collected by and hosted on G2.com.

Dorian Patricia T.
DT
Coordinador de Monitoreo y Control
Telecommunications
Enterprise (> 1000 emp.)
"Speed and open source"
What do you like best about PostgreSQL?

The first of its attractions is the speed with which it works, the larger the database at speed and the performance does not decrease, apart from the fact that it can be installed on the computer that does not have to pay for it. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Many of its instructions are complicated and not supported as should be the case for any database manager. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care
CH
Small-Business (50 or fewer emp.)
"Decent Open Source Database Platform"
What do you like best about PostgreSQL?

As with all things open source, you can't get much better than free. PostgreSql does the job, and does it well. New features are being developed all the time, so you won't be too far behind the SQL standard if you went to this product. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you are expecting top of the line software here, like Microsoft SQL Server or Oracle, you will be wrong. Microsoft spends millions of dollars in R&D to move their SQL Server product forward. You won't be getting that level of tech WOW in PostgreSQL. So you will end up having to follow traditional design patterns to accomplish what you are looking for. 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