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 12

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.
Aayush B.
AB
Software Intern
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is very robust and easy to install and configure. there are large number of add ons which can be used in this database. Overall it is best db for a developer. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

the queries which requires large calculations are very slow. Many a times i faced problem with the way its indexing work for a particular table in database which is headache for developers. Review collected by and hosted on G2.com.

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

I am using PostgreSQL for my database queries. the trigger handling property using PostgreSQL makes it very easy as compared to other db langauges. I found it very reliable and easy to use. Review collected by and hosted on G2.com.

Rahul S.
RS
Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is open source and support all SQL Operations. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I think there are not much to dislike about. Review collected by and hosted on G2.com.

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

It helps in storing tabular data. Review collected by and hosted on G2.com.

Akash K.
AK
SDE-1
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

First of all it is open source and has dedicated database connections for all mostly used web frameworks, It also provides up to date security with newer updates and almost all features are free of cost Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Speed issues with PostgreSQL performing data transactions on very large numbers.If you have worked with any other SQL, you will find PostgreSQL is similar to other SQL Review collected by and hosted on G2.com.

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

In the education field, Postgres is used over other databases because of its ease of access and quality of support in all languages. It has stronger API compatibility, cheaper support and more robust scalability Review collected by and hosted on G2.com.

Biswadeb M.
BM
Application Development Senior Analyst
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?

Open source, ready-made ide as PgAdmin tool, lightweight and easy to use Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Faced alot of database crashing and hang issues despite configuring with runnable solutions. Review collected by and hosted on G2.com.

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

Problems based on my project. Easy to use, PGadmin tool makes it easier to create and modify tables also. Review collected by and hosted on G2.com.

AMIT J.
AJ
Data Scientist L3
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I have used PostgreSQL in one of my projects. Before that, I have not used postgresql. As per clients' requirements, we have to use the PostgreSQL database. So We learned it quickly Since I have worked with other SQL previously. And find it very easy to work with PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you have worked with any other SQL, you will find PostgreSQL is similar to other SQL also, but the main advantage is it is very convenient for structured data. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I will highly recommend PostgreSQL for your work, learning, career. Review collected by and hosted on G2.com.

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

We are saving data in a structured format.

And quickly, we can make ER Diagram also.

Excellent experience working with PostgreSQL.

The client is also satisfied with our work. Review collected by and hosted on G2.com.

SHALABH S.
SS
Senior Software Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Ability to use Json type columns which lets us use it like non - Relational dbs.

Also it's completely open source.

Good for students and freelancers Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Difficulty to perform groupBy query on JSON type columns using SLICK.

Not enough documentation available for postgres using SLICK Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Best for students, start-ups or even service based companies. Review collected by and hosted on G2.com.

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

Able to use it for open source project.

Best for web site and web application products.

Rich documentation for learning.

Performs faster than MySQL ans SQL.

Multiple opensource management tool available for POSTGRES Review collected by and hosted on G2.com.

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?

Object relative, good expanding,nice features, open source and large community Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it takes more time, opensource it is a disadvantage at the same time Review collected by and hosted on G2.com.

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

Object oriented data storage is easy handling with our application, easly interfere with external languages python Review collected by and hosted on G2.com.

Haripriya B.
HB
Summer Intern
Internet
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

It is free and open DBMS software and has a good GUI feature. PostgreSQL is the world’s most advanced open source database. Developed over 25 years by a vibrant and independent open source community, PostgreSQL was born from the same research as Oracle and DB2 and contained comparable enterprise-class features such as full ACID compliance for outstanding transaction reliability and Multi-Version Concurrency Control for supporting high concurrent loads. On top of it, there is a vibrant community of PostgreSQL professionals and enthusiasts that your staff can draw upon and contribute to. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It sometimes crashed when I open it in normal mode. I need to open it in admin mode to open it. It is considerably slower than MySQL, and it does not support the entire ANSI SQL 92' standard, much less the ANSI SQL 99' standard, which is widely used in the industry. PostgreSQL is not good when it comes to performance, and It is not much popular than other database management systems, making replication is more complex. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It is highly recommended for the education field because of its good GUI feature and straightforward learning environment. I would suggest the computer science engineering people use this constantly. It's a little hard for beginners but best for professionals. Review collected by and hosted on G2.com.

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

In the education field, Postgres is used over other databases because of its ease of access and quality of support in all languages. PostgreSQL is available for almost every brand of Unix (34 platforms with the latest stable release), and Windows compatibility is available via the Cygwin framework. Native Windows compatibility is also available with version 8.0 and above. The source code is open to all at no charge. PostgreSQL is available for almost every brand of Unix (34 platforms with the latest stable release), and Windows compatibility is available via the Cygwin framework. Native Windows compatibility is also available with version 8.0 and above. Review collected by and hosted on G2.com.

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

Postgres database gives us more and more column fields that are very useful, like uuid and boolen, that other database doesn't provide. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is very slow compare to other databases like Oracle, MySQL, etc. Review collected by and hosted on G2.com.

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

Postgres stores the data of the organisation or a software that is used in companies. Review collected by and hosted on G2.com.

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

It is completely free, easy to set up, extremely robust, and has great performances on concurrency, transactions, and schema. It is also well-supported so new features and improvements are rolled out frequently. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For large-scale enterprise applications, PostgreSQL is slow. Horizontal scaling is difficult and a culprit. Could use improvements for JSON. Not a lot of online documentation and resources available compared to MySQL. Review collected by and hosted on G2.com.

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

Storing and querying a large amount of data across applications. PostgreSQL makes the ETL process very easy along with being able to onboard new team members. Overall, it enabled us to store and utilize our data well. Review collected by and hosted on G2.com.