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 30

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.
Prashil N.
PN
Research Assistant - Machine Learning and Advanced Visualisation
Higher Education
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I like the fact that it works seamlessly. No added learning is required. Any experience with other SQL tools and you can pick up PostgreSQL in a few days. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I have experienced problems of PostgreSQL hanging for huge data queries. Review collected by and hosted on G2.com.

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

I used PostgreSQL for querying massive Machine Learning datasets and finding patterns in them. Review collected by and hosted on G2.com.

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

Postgre SQL is a good open source tool to handle large amounts of data. It is cheaper compared to other tools available in the market. The installation process is very fast and smooth. Easier to integrate with a variety of ETL tools such as Informatica. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The free version has a lot of restrictions with security control and speed. We wanted to test this tool before we get a paid service but could not explore more in the free version. Review collected by and hosted on G2.com.

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

Data reliability with this tool is second to no one. Review collected by and hosted on G2.com.

Verified User in Computer & Network Security
UC
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Being able to handle queries in the graphical environment is always more comfortable and pleasant to work with. PostgreSQL has the advantage of having a very large community, which is always advantageous to have different references to lean on if needed. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is one of the most popular and always a good option, but is not thinking for companies with robust systems. But it will always be a good option to consider. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It does not take much time to learn how to handle queries and there is a lot of documentation and tutorials on the internet for free. Review collected by and hosted on G2.com.

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

It is really used for the analysis of data and generation of reports from these. 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
Verified Current User
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

its free to implenting in your system and easy to setup. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

the collation configurantion because they causes some problems in many frameworks. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

i recommend because its a free Relational Database to implementing in your system. Review collected by and hosted on G2.com.

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

the price problem, the price still low from the others and its is a good database. Review collected by and hosted on G2.com.

Verified User in Transportation/Trucking/Railroad
AT
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is a really simple and powerful relational datababase server. It is free!! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The installation process is very hard task to do. You need advanced linux knowledge to install and implement it. Review collected by and hosted on G2.com.

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

I like PostGRE only for non critical systems. It is a cheaper option and is very useful for geographical data analysys. Review collected by and hosted on G2.com.

CA
Solutions Architect
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Ease to implement and rock solid performance Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

New features are not released immediately to the open community Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Great database the has most of the same SQL as Oracle. Review collected by and hosted on G2.com.

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

Used to host an external website using all freeware software. Review collected by and hosted on G2.com.

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

The best part of offloading data storage tasks to PostgreSQL is the robustness of the database system, which is equal to any of the commercial systems. The expressiveness of the PostgreSQL is no less than that of commercial offerings, or even of experimental system for that matter. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The design seems fairly monolithic compared to newer designs, so the system has a fairly large footprint and there are few options to reduce it. A modular system might be more suitable for today's cloud servers which are extremely compact in size, and demand software that is highly optimized in memory consumption. Review collected by and hosted on G2.com.

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

Scientific workflows. The reliability saves lots of headaches when you're running experiments on other parts of the workflow. Review collected by and hosted on G2.com.

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

Postures is tool that it can be integrated with customized software till now. Has best functionality ease to use Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postures service dies once centos OS Or Helios restart. Please look into this matter as soon as possible Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Fix the bugs with Linux OS Review collected by and hosted on G2.com.

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

Nothing. Works great Review collected by and hosted on G2.com.

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

Postgresql is very light weight and easy to install . So as a DBA it is also simple to maintain. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgresql can not scale horizontally like Oracle DB. Review collected by and hosted on G2.com.

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

We found it is free open source database hence there is no license cost. Review collected by and hosted on G2.com.

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

Its relational plus no sql style with full json support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not completely no sql still has realtional touch. Review collected by and hosted on G2.com.

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

As sql server is still catching up with json support postgresql comes as a rescue for relational plus json support style db for storing most of our user data. Review collected by and hosted on G2.com.