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 29

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.
Kelvin S.
KS
Data Analyst - ETL Data Migration
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?

it has the easiest database interface which is very user-friendly with proper query return space Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

it does not have the feature of table or schema prediction, makes it laborious and time-consuming typing a search Review collected by and hosted on G2.com.

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

I created a database and tables for a client . also created logins for other end users from the client side and allowed them to have host capabilities as well Review collected by and hosted on G2.com.

Nikhil J.
NJ
Associate Team Lead
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I like the techniques as in SQL we can't store the Json and all but here storing the whole Json was a big advantage instead of writing all the fields to database Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The UI is little clumsy as I have used in linux through dbeaver Review collected by and hosted on G2.com.

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

Storing the map force electronic data files converting g to Json and stories g I to it saves a lot of space Review collected by and hosted on G2.com.

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

It is an industry standard especially for database management in large scale application. Works quite easily Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not as customizable as MySQL and no covering index support Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Use if it you need something easy to start with Review collected by and hosted on G2.com.

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

Database management Review collected by and hosted on G2.com.

Vishnu P.
VP
Sr. Cloud Consultant
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

PostgreSQL is simple is having the lowest learning curve and it's lightweight too. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It requires much more resources to execute when there are multiple queries running. Review collected by and hosted on G2.com.

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

Building a database, Better management of data, Best to use with Python Flask Review collected by and hosted on G2.com.

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

Is very useful for our edi applications in terms of efficiency Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The syntax feels a little redundant and tends to be a lot pickier than some others Review collected by and hosted on G2.com.

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

It is very efficient for managing Edi Systems likes it earlier Review collected by and hosted on G2.com.

EW
IT Project Manager
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Seller invite
What do you like best about PostgreSQL?

The simplicity in the software, it detects IP addresses automatically without manual configurations which can be hectic to the technician. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it gets disconnected to the database and one has to configure it a fresh in order to collect information from the database. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is very user friendly as even learners can use with with no experience at all i would strongly recommend it to Others Review collected by and hosted on G2.com.

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

Using it to to store data of a management software that we design to our clients Review collected by and hosted on G2.com.

Verified User in Accounting
CA
Mid-Market(51-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?

I love this engine, I have worked with this database since 2010 and always have new features, open source, great forum and if you need additional features you have other tools based in this code Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Many people think that is a difficult database because documentation is not friendly, technical concepts that not all can understand immediately Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Introduce to postgresql, there are many resources online for training and help you in the path Review collected by and hosted on G2.com.

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

Load balancing, fail over and high availability are the principal solves that I use in my business. I don't need to acquire commercial products because I can found all in open source for postgresql Review collected by and hosted on G2.com.

Alexandra G.
AG
AVP of Cyber Security Data Science
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

Installation and integration with my work environment was easy. I use it often. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I honestly have no complaints. I love how easy the controls are to find. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Great product Review collected by and hosted on G2.com.

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

I access temporary company data. 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
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

the strictness of the system allows for better security, while the features let us make the tables work as we desire. And all of that using SQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much to be honest. Maybe how hard it was to make it work at first. Or the fact that permissions are directly wiped with the tables. Which may be for the better. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

write your tables beforehand and don't rely on pgAdmin to do your job. Review collected by and hosted on G2.com.

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

It lets us store all the data we need in a reliable environment so that we can trust the data will stay intact. Review collected by and hosted on G2.com.

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

Open source, easy installation and read to use. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Hard to hand code error and does not support sql syntex Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Hard to get use at first but provide a scalable solution Review collected by and hosted on G2.com.

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

Creating a Paas using AWS cloud Review collected by and hosted on G2.com.