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 5

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.
Manthan V.
MV
SDE-2 Frontend Developer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

=> SQL database

=> Open-source database it means we can do customization and get community support

=> Easy to manage large volumes of data

=> Allow creating custom data types, operators, events and function

=> Large community so you can solve you problem fast

=> Provide jsonb data type for store json data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

=> database is based on project and requirement so if your project is small then I suggest use MongoDB

=> Need the training to understand database functionality

=> Need more storage and computing power to execute query Review collected by and hosted on G2.com.

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

=> Allow writing complex queries so we can get more meaningful full data in a single query instead of executing multiple queries

=> Multiple users can access the DB in the same time without any issue so its not block users

=> Create custom type, event, functional, and operator it means base on requirements we can create and reuse instead of writing custom logic Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
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 we can use it in our production environment, it provide very good features so that we can optimized our query and also data retrieval become easy also in PostgreSQL querys are easy to write, we frequently use it in our projects. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

what i don't like is, it is not distributed database, and some features are not supported Review collected by and hosted on G2.com.

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

They make some features simple, so that now we can easily write our complex query 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
Verified Current User
Review source: Organic Review from User Profile
What do you like best about PostgreSQL?

Is the best database to store the geom polygons Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The sintaxes from some functions are not easy to understand Review collected by and hosted on G2.com.

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

There is no issues Review collected by and hosted on G2.com.

AG
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 ability to store NOSQL data as well such as JSON

-Well suited when data is transactional as well as informative

-Free to use

-Postgres's ORM is available For almost all major programming language

-Installation is very straightforward

-Easy to maintain compared to other SQL databases Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

-Not as fast as MySQL

-Without ORM, Query writing can be tedious and slow

-As it supports JSON schema as well it can be difficult to manage at scale

-Horizontal scaling can be trickier to achieve Review collected by and hosted on G2.com.

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

It works best when dealing with mixed types of data such as transactions, spatial, and geo-location as it can also store data in document format, unlike any other SQL database. Also its well suited if you're planning on vertical scaling of the database. Review collected by and hosted on G2.com.

Ankit A.
AA
Senior Technical Consultant Database
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?

What I like most about PostgreSQL is its open source. Being an open-source relational database, it also provides value to the customer and their users in terms of fast and internal precalculated libraries and functions that help developers and users retrieve data fastly without any hurdle.

Postgresql is also helping us with fast query execution and efficient use of memory. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Being an open-source relational database, the area of improvement is its inability to handle large-volume database application support.

Another thing is its limited community or ecosystem compared to premium databases like oracle and SQL servers.

The query execution explanation plan is also not good in PostgreSQL.

Postgresql does not have any run-time debugger, so some time to hard to find the error's root cause. Review collected by and hosted on G2.com.

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

Postgresql provides a relational database system that is helping startups and developers to learn databases and adopt new technologies that can't pay licensing fees.

It helped me to generate a geo-tagging platform that required a fast and accurate lat-long calculation that couldn't be completed without the PostgreSQL / PostGIS.

Postgresql helped me to learn how we could integrate json with RDBMS. Review collected by and hosted on G2.com.

Kartik B.
KB
Software Trainee
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?

I have used this software for Blog Platform Management. It was very helpful & easy to manage data. It provide easier & userfriendly queries to all users. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Integrating with framework it is very time consuming. Review collected by and hosted on G2.com.

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

It manages data for user and provide direct access to data present in Database. Review collected by and hosted on G2.com.

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

The PostgreSQL relational database is a open source database system - which is free to use, easily configurable and carry overs all the basic SQL principles and Syntax. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is a downside of the PostgreSQL that it is not able to handle multiple idle connections, it loses the ability for new connections to reconnect. If that can be fixed, it's awesome. Review collected by and hosted on G2.com.

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

It enables organizations and users to create, manipulate and configure a relational database into a business use case. It is free to use, and the saves licensing costs while providing reliability. Review collected by and hosted on G2.com.

Mohit S.
MS
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

It is a open source application and allows to scale whenever needed. It is very fast and secure to manipulate data. Database creation, updation is very easy in PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Learning PostgreSQL is challenging in beginning because it is complex and documentation is not that much easy to understand. The documentation should have examples for reference. Review collected by and hosted on G2.com.

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

I have huge real time data to manipulate. When I used other framework the performance of data transfer was low. With the help of PostgreSQL I achieved data manipulation faster. Review collected by and hosted on G2.com.

Jasmeet K.
JK
Data Scientist
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I have used Postgres SQL extensively for the past few years and it is few of cost effective scalable RDBMS that runs very smooth with web applications specially with Django backend. This RDBMS can be tuned for performance quickly and offers amazing support for custom functions.

This RDBMS can be scaled quickly and is available in cloud services like Amazon RDS which can make this database manageable. The error messages in the RDBMS is very clearly laid out and I just love the way it provides flexibility of using custom SQL workbenches. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I have loved my experience with Postgres SQL and the user community for this RDBMS is amazing. I have faced issues in reading documentation for Postgres but online community has always helped in getting my issues resolved. Review collected by and hosted on G2.com.

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

PostgresSQL has been a goto database management system in our projects because of its flexiblity and seamless integration with Django. I have been using PostgresSQL extensively for data storage and analysis. This RDBMS is really cost effective and we use it in Amazon RDS for production instance. 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
What do you like best about PostgreSQL?

Very reliable tool to use and easy to understand plus its consistent and also adapts to changing infrastructure in the market. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The documentation is very dense which is nit easy to understand by beginners. Review collected by and hosted on G2.com.

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

It helped to solve the business queries and business cases and it can also deal with a wide range of data types including specialised ones. Review collected by and hosted on G2.com.