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 26

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

PostgreSQL

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.

Recent PostgreSQL Reviews

AK
Akshaya K.Small-Business (50 or fewer emp.)
5.0 out of 5
"i am using this as my database since 2024 i love this product"
we can automatically create a ER diagram of a databse with 2-3 clicks . its very easy install in my system the storage was very low and easy to in...
Biruk T.
BT
Biruk T.Mid-Market (51-1000 emp.)
5.0 out of 5
"Robust PostgreSQL support with enterprise grade features"
EDB provides a reliable PostgreSQL experience with extended enterprise tools like EDB Postgres Advanced Server. I specially appreciated the integra...
Verified User
U
Verified UserSmall-Business (50 or fewer emp.)
5.0 out of 5
"PostgreSQL:"
Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in J...

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
View More Pricing Information

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Answer a few questions to help the PostgreSQL community
Have you used PostgreSQL before?
Yes

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.
Verified User in Information Technology and Services
II
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Postgres data base is light weighted and flexible data base.Recently we have migrated to Postgres and its really easy to develop and maintain.Since it is open source we got advantage to spend money on cloud services to maintain independently.This data base has lot features and we can use for large scale applications. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some of the common SQL language syntax can be maintained without customizations.Some time we feel difficulty to find syntax in online.Otherwise, this DB is better than other open source DB tools.Some times we found some bugs which is related to tags and queries, especially libraries can be improved and documentation can be provided in detail level. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Strongly recommended DB for any open source ideas. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We are able to reduce cost by migrating to open source Db. We are able to separate all functions and views without any extra efforts while migrating. These DB helped us to reduce overall cost in Cloud as well, on top of all advantages, query language is very simple. Review collected by and hosted on G2.com.

Verified User in E-Learning
UE
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Well, over time MySQL and PostgreSQL have grown closer and closer together, but for the longest time I've enjoyed using postgres over other free open source RDMBS because it had more analytical functions. Postgres has been supporting tricky things like window functions which was always super useful for tricky aggregations for reports.

However, what I like best about postgres is probably the actual documentation that is easily available that includes tons of explanations and examples. This means I can quickly make changes and figure out how to make my application needs work just by myself, even if I've never had to use Postgres or another RDMBS to do that task before. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I can't say I dislike anything about postgres. The things that are 'bad' about postgres are what you get for having a relational database that uses hard disk as storage. But those are normal things that honestly don't usually slow you down or hurt your application.

Sometimes I'll use redis for a fast, non-relational in-memory database, but otherwise I always use postgres since it's free, documented well, and a great tool. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

These days you can drop in replace for MySQL pretty much, but I prefer postgres for the great documentation. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Well, I simply use postgres to save data in one place like any database. Postgres is a great open source relational database system so it helps keep your data in one place and normalized. I will often setup mini web apps for my company's other teams to quickly pull/aggregate data and reports, and postgres is great for that. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Well documented installation procedures for most common Linux OS, query language and security rules Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Absence of GUI editor and absense of compatibility with old version of phpmyadmin Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Use pgAdmin as an alternative of phpmyadmin Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Get improved performance from a web-app that was previously using mysql server Review collected by and hosted on G2.com.

SJ
Samarth Jain
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

1. Postgres is open source and free to use.

2. Postgres is Acid compliant and thus no data is lost.

3. Since PostgreSQL supports JSON field which was not supported by Mysql which we were using before, it has become very easy for us to work with JSON data sets. We can easily query JSON fields using Postgres query language.

4. Postgres also has a very strong community, thus it is very easy for new developers to adapt as they can easily find support online Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I couldn't find anything to dislike in PostgreSQL till now as it gives me all the features that were required in our web application. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

A very powerful Rdbms Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

1. Postgres has helped us to store and query JSON fields which was the biggest problem that we were facing with mysql. Review collected by and hosted on G2.com.

Sharad K.
SK
Software Engineer - R&D
Information Technology and Services
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It includes most SQL data types, including integer, boolean, char, date, and timestamp.

It has native programming interfaces for C/C++, Java, Python, Ruby,

Within a single column you can have a range from one value to another–this is especially helpful for time ranges.

And one of the best thing is Foreign Data Wrappers which are really helpful. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is bit harder to get support or to google for results

Replication is not yet as well implemented

Doesn’t support CTE.

Doesn’t support working with arrays which is the major drawback for Software Developers or data scientists. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Support with Array Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Whole company database is using Postgres Review collected by and hosted on G2.com.

AG
Sr. Software engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Ease of use, lots of command line options, and a good UI to manage Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Every time in the query we have to double quote the table/column name. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We use it embedded in our product Review collected by and hosted on G2.com.

AS
Intern
Internet
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

PostgreSQL is user-friendly and GUI based database which is convenient for students to use. That's the best thing I like about it. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't have any dislikes about PostgreSQL, because it's in the best stage of performance. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

For free and open sourced database software, pls use PostgreSQL because it is the best I can recommend for students. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I used Postgresql for my database project in which I saved all the data to be displayed on a PHP based website in PostgreSQL. I was easy to connect between the database and PHP and my project was successful. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Free and Open Source, constantly making updates. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Typically work with MySQL installations. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

You might want to see what Percona has to offer. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Django minimally, none really. Review collected by and hosted on G2.com.

Verified User in Architecture & Planning
UA
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Translated Using AI
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

The simplicity of use and the good performance in handling data of this type. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is not possible to use it for mass storage. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Stability and price have no rival. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

The use of georeferenced data that allows its use without the need to use Oracle. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
II
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

This DB is open source and its really useful for any small or large scale projects.We are using this from last couple of years and it seems to be very useful product till now.Migration is really easy and SQL can be maintained in well manner.This DB helped us to overcome some performance issues and its really useful to reduce cost. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some of the query tags is not supported in postgres and query language is difficult to understand for initial beginners. This can improved and documentation is hard to follow. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Strongly recommended product for large scale projects. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

This DB helped our team to reduce maintenance support and it is easy to deploy in cloud. It also helps our teams to manage functions , views and other code in well defined format and performance was really good. Review collected by and hosted on G2.com.