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 27

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 Computer Software
UC
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Open Source DBMS. ...

Diverse Community. ...

Function. ...

ACID and Transaction. ...

Diverse indexing techniques. ...

Flexible Full-text search. ...

Diverse kinds of replication. ...

Diversified extension functions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The client used to connect to posgres breaks, for example never use pgadmin to connect to this database. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Do not connect it with the client pgadmin, It always breaks. Needs restarting the client every single time. Review collected by and hosted on G2.com.

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

Data replication is a big advantage. If your data is in one of the cloud regions it gets replicated in to an other region with in fifteen minutes. Review collected by and hosted on G2.com.

Verified User in Transportation/Trucking/Railroad
AT
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?

it's a very good database management system. it has great features and flexible options, even though the syntax is strict enough to provide correct security and reliability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I guess it could use some easier user management queries but it's ok. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

know your sql, and not just mysql. use the documentations and the latest verions. Review collected by and hosted on G2.com.

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

we needed a 100% reliable database system for our semi-cold data. so we went with the most reliable of all, even if we may sacrifice some performances. Review collected by and hosted on G2.com.

Jennifer G.
JG
Pharmacy Technician
Hospital & Health Care
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

This is an amazing database! Not only is it reliable but It has great features that make it easy to store data and use multiple languages. It's easy to customize and I love that it is compatible with Linux as that is what I primarily use. Also, it is great that there is a community still involved in this software who are able to teach new (or even experienced) people using PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I've had some issues with PostgreSQL running a little slow and I'm not a huge fan of all of the syntax, as some of it seems a bit counterintuitive. As a result, I think it is pretty difficult to use as a beginner. Review collected by and hosted on G2.com.

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

As an intern, I primarily used PostgreSQL to manage simple tasks under some guidance. However, even in that role I could tell that it is a very powerful database with a lot of benefits to someone who knows how to use it. Review collected by and hosted on G2.com.

MP
Software Programmer
Banking
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The fact it is an open source database which means its free to use.

Postgre has multiple updates a month, making it ever improving to be the best database software possible.

PostgreSQL's query optimizer is far superior to many others it makes retrieving information and the data you need almost instantaneous. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's takes awhile to load due to using all allocated resources from your computer.

It's also causes computers to crash depending on the size of the database(mind you these are older computers/laptops using not the best of processors). Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I would recommend Review collected by and hosted on G2.com.

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

It allows us to grab out clients information in a matter of seconds.

It also allows us to update delete and insert new customers as the click of a mouse no query writing, saving time and giving us more time to devote to our clients. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
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?

It's a very robust product with a lot of features. We have been using it a lot and it's very reliable, flexible and scales accordingly. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some quirks that are particular of postgre, like the fact that count operations can be very slow. Review collected by and hosted on G2.com.

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

We use it as our main DB for most projects. It has a very rich set of features and it performs very well for our use cases Review collected by and hosted on G2.com.

Verified User in Consumer Goods
AC
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is a high-performing, robust, stable, and fully-featured RDBMS. It is highly-extensible via a wide variety of languages. It has all of the features of any of the leading commercial databases, for a slight fraction to none of the cost. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Literally nothing - there is nothing about PostgreSQL that I dislike. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Just use it. Don't let the Open Source nature of the software scare you - it's a completely robust and stable solution. Do make sure that you treat it as you would any other RDBMS, particularly when it comes to doing proper backup. Several vendors have tried to use PostgreSQL as some sort of "embedded" database, and bad things result. It isn't the fault of PostgreSQL, it's how you use the software. Review collected by and hosted on G2.com.

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

Reducing reliance on Commercial databases, and opening platform support to a wider range of platforms. Review collected by and hosted on G2.com.

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

This is an amazing database! It works extremely fast for applications including very complex queries as well

They provide one of most complete and precise documentation in the open source market and even compared with a few proprietary projects. Not only is it reliable but It has great features that make it easy to store data and use multiple languages. PostgreSQL is a great open source relational database system so it helps keep your data in one place and normalized. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL can provide richer auditing options as the current options are enough for few large enterprises Review collected by and hosted on G2.com.

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

I have used it as the database in a data warehouse solution, data mining millions of rows. Review collected by and hosted on G2.com.

George L.
GL
Data Engineer
Computer Software
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
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?

The greenplum database running PostgreSQL is a good database for large workloads that run on massively parallel databases like Greenplum. I can distribute the tables by a certain column identifier and be able to link different tables together for efficient workloads. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I dislike the PGAdmin III interface which is made for PostgreSQL developers because it's an old program and the new one, PGAdmin 4 does not support older versions of PostgreSQL databases. Version compatibility is a big deal and my company still uses the older version of PostgreSQL so I am stuck with using an older version of the application to manage the database. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

For companies considering PostgreSQL, you need to seriously consider the backend provider whether it be Greenplum/Pivotal or Amazon, you must make the proper selection that will be sufficient for the data that you are working with. With Amazon Web Services, it becomes price efficient to run these databases in the cloud at a reasonable cost with great efficiency. Review collected by and hosted on G2.com.

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

PostgreSQL has been able to help us conduct data quality operations and archive data in an efficient manner. Review collected by and hosted on G2.com.

Verified User in Alternative Medicine
IA
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 fast with very slow latencies and is available on most of the clouds. I find it's SQL flavor, particularly amenable to my style of coding and easy to interface to natural query.

It is robust and always works, without crashing and easily distributable. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is not yet extended to a NoSQL formulation and has limitations on blob objects. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I would definitely recommend PostGRE, to anyone needing an honest, high performing and reliable database. Botlibre, a company I work with uses postgre for all its bots and it is robust. Review collected by and hosted on G2.com.

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

I have used postgre for medical records and for hosting compressed archives on my local server. I now use it as a plan B on AWS RDS. Review collected by and hosted on G2.com.

Sainath J.
SJ
Team Lead
Information Technology and Services
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

Postgre SQL tool is very much capable enough to handle huge data like Oracle Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Has delayed response sometimes which updating the Database Schema Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

massive tool which can handle huge business transactions Review collected by and hosted on G2.com.

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

Building schema as the backbone for the front-end ERP tool Review collected by and hosted on G2.com.