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 50

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.
Stanislas J.
SJ
Administrateur du SIGB
Libraries
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Very fast for running queries from bash or within PGAdmin ; ability to lauch queries from PHP Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Using variables in not as simple as in MySQL. I prefer PgAdmin 3 rather than PgAdmin 4. Review collected by and hosted on G2.com.

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

I was able to develop web applications to get data from the database, et display them in attractive webpages (thanks tou Highcharts and LeafLet). Review collected by and hosted on G2.com.

Ryne L.
RL
Account Manager
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Functionality and organization of data is clean and concise Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

installing the application/software can be challenging for newer/less-experienced users. Review collected by and hosted on G2.com.

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

Organizing user and website data quality and metrics Review collected by and hosted on G2.com.

SN
Student Assistant
Hospital & Health Care
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

This database allow us to interface the databases in a nice GUI that will interact with the database inside. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The GUI was a little slow and took a long time to run script to generate data. Review collected by and hosted on G2.com.

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

This allow us to connect to a e2 database instance provided and managed by amazon Review collected by and hosted on G2.com.

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

I've been using PostgreSQL for many years, and although there are alternatives, I've found that for most use cases PostgreSQL is the RDBMS to go for.

It's not only because of its simplicity or its features. The main reason is that it is tuned to most workloads and you don't have to fine-tune or play with configuration files a lot: it simply works.

This really feels like the developers put a lot of care when designing the RDBMS engine and when choosing defaults. I still have to find a workload PostgreSQL is not suited for. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

This is not a complain, as I'm okay with the command line and fine using and configuring it through SSH in my servers, but a lot of colleagues find it difficult to do this. Most of them, accustomed to point-and-click solutions, or more mainstream databases, find it difficult to make the switch. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Don't be amused by its complexity or lack of desktop applications for management. It is a really powerful RDBMS engine, and although it can have some rough edges, overall is one of the most powerful contenders (even against commercial and expensive solutions, like Oracle or SQL Server). Review collected by and hosted on G2.com.

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

When there are applications that cannot be handled with standard solutions, I toss the data to a PostgreSQL database and give it a go. It is not the de facto database for my current company, but I use it when required, as SQL Server (the one we use the most) cannot handle some workloads. Review collected by and hosted on G2.com.

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

Performance almost at par if not better than some of the commercial products out in the market. Supports a broad array of data types out of box. Open Source. Strong developer community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Might suffer in speed especially if the queries are not well written. (Unforgiving in general, which might be a good thing). Generic Error Messages Review collected by and hosted on G2.com.

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

Store/Manage/Retrieve business data.

Benefits: Easily scalable, highly performant. Review collected by and hosted on G2.com.

Jemal M.
JM
Software Quality Assurance Engineer
Computer Software
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Easy to use,good online support community,open source and available as a docker image Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Very strict on syntaxing and debugging not easy Review collected by and hosted on G2.com.

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

To store metadata by creating schemes and databases Review collected by and hosted on G2.com.

Verified User in Retail
AR
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

Simplicity and how easy it was to set up. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The product is lacking some features that are norm these days for a database engine. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

When you need a database engine/storage which is easy to integrate into the logic of your in-house application, capable of supporting SQL alike queries - PostgreSQL is the way to go. Review collected by and hosted on G2.com.

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

An in house application was using this database to store the results persistently. Review collected by and hosted on G2.com.

Cédric T.
CT
Cofounder, CTO and software developer
Internet
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

user interface and commands are easy and comprehensive. It is well integrated into every application for web, mobile etc... Most useful database system for lots of data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much. Some times I forget about the commands in terminal Review collected by and hosted on G2.com.

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

Storing data for web applications and mobile Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising
AM
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Cross platform

Designed for high volume of data.

Never crashes and is at no charge.which is the best thing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not great to interact with web applications. Review collected by and hosted on G2.com.

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

Figuring out where is the problem is crucial while solving business problems

Its because it uses MVCC data storage strategy.It never crashes inspite of high activity usage. Review collected by and hosted on G2.com.

Nag T.
NT
Senior Software Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I love PostgreSQL than any other Databases Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

for beginners (new to Database) Installation and configuration is a bit difficult Review collected by and hosted on G2.com.

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

we use as our Database for all our projects Review collected by and hosted on G2.com.