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 58

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.
Ralph S.
RS
Position Seeker
Information Technology and Services
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Elegance, intuitive feel. Great manual. Endless improvements. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

hard to keep up with all the enhancements! Review collected by and hosted on G2.com.

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

Recently used PG to clean and merge data from two Washington State sources on business owners.

Has every feature needed, including using it's unique DISTINCT ON() function. Review collected by and hosted on G2.com.

Dan J.
DJ
GIS Officer
Non-Profit Organization Management
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is well-documented, powerful, mature, and has a huge user base. Easy to find examples and forum postings when troubleshooting just about any scenario: the odd error message, problems using pgAdmin, figuring out how to integrate PostgreSQL into your node.js application. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For some use-cases, PostgreSQL isn't the best option. It's worth considering your needs and looking at SQLite, MongoDB, and others. Review collected by and hosted on G2.com.

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

We needed an open source database for a variety of one-off web apps and dashboards. Postgres does a great job of it. Review collected by and hosted on G2.com.

Ian H.
IH
Programmer
Computer Software
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Coming from a MySQL background, I love the variety of data types in Postgres: JSON, arrays, etc, all fill a need that MySQL didn't. I especially like how easy it is to manipulate dates, something that has sped up development a ton in terms of automated testing. The ability to enforce checks on insertion is very helpful, too. I've used NoSQL before, and I much prefer the rigidity of an RDBMS. All too often I've had to deal with corrupt data because of the temptation to fool around directly in the database rather than using the application layer. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Probably the most difficult thing about Postgres is its permissions model. It's not very intuitive, in my opinion, and I think those issues need to be resolved before it can gain the sort of traction MySQL has. Right now it's just not easy for a beginner to get set up and secure. Review collected by and hosted on G2.com.

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

We've mainly used Postgres as an inventory system; nothing too fancy, but Postgres has made it much more enjoyable. Review collected by and hosted on G2.com.

Verified User in Legal Services
AL
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

love the aggregate functions, also JSONB support, as well as views and materizlized views maintenance. very stable and secure. It is easy for me to maintain as an analyst Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

certain data types are not good. i find the admin tools to not be amazing either Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

i would recommend as a data analytics database. It can be difficult to scale and if you have a lot of data that doesnt easily translate into columns (json) unless you are using a vendor to complete ETL process. I love postgres tho :) Very stable and secure and documentation is great Review collected by and hosted on G2.com.

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

I use postgres as a analytics data warehouse only. I allow acces for all other analysts, and sit analysis tools on top. this works quite well. I am often looking for ways to optimize queries tho Review collected by and hosted on G2.com.

Hakim B.
HB
PhD Student
Higher Education
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL seems to scale well compared to MySQL, which means that it's more capable than the latter to withstand a larger database and an increasing number of transactions and connections. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The learning curve seems a bit steep compared to MySQL. And therefore, a beginner might struggle to get started with it. Pgadmin is also not as intuitive as PhpMyAdmin for example and takes a bit of time to get used to. Review collected by and hosted on G2.com.

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

A website side-project to gather quotes. Review collected by and hosted on G2.com.

Verified User in Aviation & Aerospace
UA
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

For the basic level of DB functionality that I need, I honestly see no difference between this or other similar software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing, it works just fine for my needs. Review collected by and hosted on G2.com.

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

storing and access various large set of configuration settings, and snapshotting states of a system Review collected by and hosted on G2.com.

McCourt C.
MC
Systems Development Manager
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Postgresql is a very lightweight cross platform solution.

This makes it a perfect alternative to some of the larger commercial solutions out there right now.

The community behind it is also first class, loads of support is available via the forums when needed.

My favorite feature however is replication.

Although you will be editing text based config files to get set up, you can literally have one database replicating to another in half an hour(for basic configs).

I know this is possible with other commercial tools, but Postgres is free to use.

I use it for all of my personal projects when possible.

Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its a little tricky to configure for those who are used to graphical interfaces like in MS SQL server. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Join the communities and read as much as you can about the config.

Dip your toe in and you will be surprised what Postgresql can do and how fast it can be. Review collected by and hosted on G2.com.

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

Really again the replication has allowed us as an ISV to offer enterprise level service to clients whom may not otherwise have been able to afford to do it with commercial offerings. Review collected by and hosted on G2.com.

Anson A.
AA
Data Czar
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?

open source, large community, some nice functions that get updated. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

parallel queries not available yet.

not as frequent w/ patches or new function releases Review collected by and hosted on G2.com.

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

RDMBS for reporting and meta info storage Review collected by and hosted on G2.com.

Rob M.
RM
Director of Software Development
Health, Wellness and Fitness
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Solid SQL database, all standard SQL syntax supported with many nice extensions.

Stable

Excellent documentation and good develop support community

Full internationalization support

Good performance

Support for advanced SQL features, like "WITH" clauses and POSIX regular expressions

Built-in full text search (tsearch)

Support for distributed databases - master/slave replication

Lots of native "C" extensions

Right price - open source

Runs on Windows, OSX, and Unix

Installs on OSX using HomeBrew. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PgAdmin tends to crash, losing your query, when you resize the query window. That's been true for over 5 years now. I wish they'd fix that. It might have flaws as larger scales that I use it at, but I haven't seen any yet. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Best open source database out there, definitely better than paid databases like Oracle, and probably better than SQL Server. Review collected by and hosted on G2.com.

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

It's a database ;) Review collected by and hosted on G2.com.

chedi t.
CT
Consultant
Computer Software
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I've worked with many relationnal databases over the years and mysql was my goto solution for web development for a while. Until I was forced to use postgis extension of postgresql for a geospatial data storage project. Since then, postgresql became my defacto databse.

Very reliable, great performance and advanced features make postgresql a solution for midium to large deployment. Advanced data types, especially spatial in my case, rich feature sets and the possibility to write stored procedures in python are a deal sealer.

It's also opensource, with a good support and a welcoming community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing really, but there is some known gotcha and behaviors that can be confusing for new users. Reading the documentation is a must even if you have a background with other RDBMS.

Tunning the performance of the system is up to the database administrator and the number of options can be overwhelming sometime. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Postgresql is a very advanced database system with an emphasis on extensibility and customization. The documentation is quiet large and the options multiple and you will likely take you a long time to figure it all out but it's all worth it in the end. Review collected by and hosted on G2.com.

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

Postgresql is really the most advanced and reliable database that we have used yet. We are using it in conjunction with Django web framework and a geospatial systems using the postgis extension.

The cost/quality ration is just unparalleled with any other solution. Review collected by and hosted on G2.com.