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 14

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

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...
saif eddine m.
SM
saif eddine m.Enterprise (> 1000 emp.)
5.0 out of 5
"My Experience With PostgreSQL"
What i like most about PostgreSQL is the ergonomic interface , easy to understand .

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

637 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.
637 PostgreSQL Reviews
4.4 out of 5
637 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 Information Technology and Services
UI
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
What do you like best about PostgreSQL?

PostgreSQL is open source, and we can use it in any OS like Windows, Linux, etc. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A stored procedure is not fully supported here, and we can not return a dynamic table. Also, his output window returns only a single query result. Review collected by and hosted on G2.com.

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

With PostgreSQL and dot Net Core, we have built health care products, and because of his multi-support features, we can run our application into many OS Review collected by and hosted on G2.com.

Naveed A.
NA
Angular & React Developer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The relations among the tables to avoid duplicate data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Limited JSON data support therefore we need many number of tables Review collected by and hosted on G2.com.

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

ERP issues by using DB in a relational way Review collected by and hosted on G2.com.

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

The code/Query you type in the database, if overwritten by another new query by user, the previous query /Queries will still be available in the history, which you can easily refer to and copy the old code Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There's not much to Dislike to be honest - but every database may have some or the other query restricted limitations. Such as, in PostgreSQL I could'nt use the LIMIT command and few more - which were working in MySQL server. But other major things were working fine only. Review collected by and hosted on G2.com.

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

I used to practice SQL for personal skill development on both MYSQL server and PostgreSQl and in that I used to analyse the auto market database, to dig out insights related to recent and historical trends Review collected by and hosted on G2.com.

Prasad B.
PB
Principal Consultant
Enterprise(> 1000 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?

- Easy to code and interpret.

- DB compatible Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Need to get more in-built libraries and opcodes. Review collected by and hosted on G2.com.

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

- performance engineering and migration Review collected by and hosted on G2.com.

Franco M.
FM
PLSQL Developer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It's similar to oracle and mysql but it's free Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

UI is not the best. Could be even better. Review collected by and hosted on G2.com.

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

Database for a labor union implementing Adempiere Review collected by and hosted on G2.com.

Jagruti P.
JP
Senior Analyst
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

- Simplicity and flexibility compared to other SQL databases.

- Logging is available for each and every activity if you eneabled that so its easy to understand if some users has changed any data.

- We can use complex data types which is available in postgres like geographic objects which help us to manage location data in the database if your application needs to manage user or other location.

- English Documenetation available for easy of use and that will not take much time to learn this database Software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- The speed of fetching data is very low compare to others.

- Each and every open source software not support PostgreSQL compare to mySQL which support most of each and every open source sotware. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Check your requirement before choosing this database or any other relational database. If your condition is to read data from the database too frequently, then it might be slowness shows in your whole application. Review collected by and hosted on G2.com.

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

- Firstly, I solved many issues using this database. I like it the most because we can use both the console and User interface to manage the database.

- Secondly, we can use easily use AWS RDS to manage this database as RDS contains its configurations.

- Third, My requirement is to read data from Queue and then process data and store in database based on schdeuler which is run timely basis so I didnt find any slowness in my system bacase all things are managed at background level. Review collected by and hosted on G2.com.

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

When you think about the performance of a database and it's robustness postgresql is the best option. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Pg admin should be simplified,some times split windows are too crowded to look at. Review collected by and hosted on G2.com.

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

As the system gets bigger the queries got complicated then postgresql is game changer. Data analysis is also a great boost to system. Review collected by and hosted on G2.com.

Charlie O.
CO
CTO
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?

Postgres is rock solid, widely available, and very performant. In my opinion it is usually best to start with everything in Postgres and spin things out as you scale. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much; integrated connection pooling would be nice. And a native column store option. Review collected by and hosted on G2.com.

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

Full stack webapp deployment. Postgres has allowed us to deploy and iterate rapidly. Review collected by and hosted on G2.com.

Wade W.
WW
Director of Information and Analytics
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?

Postgres has many of the features that I have come to enjoy in more enterprise-scale databases, with the benefit of an open-source pricetag and community support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you are looking for a vendor, Postgres isn't your tool. In many ways though, that is a positive. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are comfortable doing a little sys admin work to get it up and running, you probably already know that Postgres is the way to go. Review collected by and hosted on G2.com.

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

Postgres was our primary data store for many years for our centralized data warehouse. Any relational data can be stored in Postgres, and there is broad support for clients and other tools to interact with that data. Review collected by and hosted on G2.com.

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

Dynamic creation of tables/models differenciate from other databases Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing which I can think of and its best and mostly used database Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is most widely used database worldwise Review collected by and hosted on G2.com.

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

Relational database structure with dynamic model generation Review collected by and hosted on G2.com.