Best Software for 2025 is now live!
Save to My Lists
Claimed
Claimed

Top Rated PostgreSQL Alternatives

PostgreSQL Reviews & Product Details

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 Details
HQ Location
United States
Twitter
@postgresql
51,720 Twitter followers
LinkedIn® Page
www.linkedin.com
77 employees on LinkedIn®
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.


Avi A.
AA
Overview Provided by:
CTO at Coronys LTD.

Recent PostgreSQL Reviews

Diego G.
DG
Diego G.Mid-Market (51-1000 emp.)
5.0 out of 5
"Simply an amazing tool"
It's very powerful and versatile, and has a huge ecosystem built around it. It's the de-facto solution for so many problems nowadays.
Aavinashh L.
AL
Aavinashh L.Enterprise (> 1000 emp.)
4.5 out of 5
"PostgreSQL is robust database to rely on."
Its wonderful DBMS that has wide range of extentions and relaibiility features with great customer support
Akshay P.
AP
Akshay P.Small-Business (50 or fewer emp.)
4.5 out of 5
"PostgreSQL Performance Insights"
One of the best part is Open source, Handle large datasets, strong security, easy to use and most important community support. Also It provide adv...
Security Badge
This seller hasn't added their security information yet. Let them know that you'd like them to add it.
0 people requested security information

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Answer a few questions to help the PostgreSQL community
Have you used PostgreSQL before?
Yes

Video Reviews

634 PostgreSQL Reviews

4.4 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Popular Mentions
The next elements are radio elements and sort the displayed results by the item selected and will update the results displayed.
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.
634 PostgreSQL Reviews
4.4 out of 5
634 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

Overall Review Sentiment for PostgreSQLQuestion

Time to Implement
<1 day
>12 months
Return on Investment
<6 months
48+ months
Ease of Setup
0 (Difficult)
10 (Easy)
Log In
Want to see more insights from verified reviewers?
Log in to view review sentiment.
G2 reviews are authentic and verified.
Akshay P.
AP
Data Science And Business Analytics intern
Retail
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?

One of the best part is Open source, Handle large datasets, strong security, easy to use and most important community support. Also It provide advance features like: support complex qeries, Custom functions Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

one thing i.e. fewer GUI tools compared to other database like MySQL Review collected by and hosted on G2.com.

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

It addresses the need for scalability by efficiently handling large datasets and supporting complex queries, making it ideal for big data and analytics. Additionally, PostgreSQL simplifies complex data handling with support for advanced data types like JSON and arrays, allowing businesses to manage structured and unstructured data seamlessly. Review collected by and hosted on G2.com.

Diego G.
DG
Engineering Lead
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

It's very powerful and versatile, and has a huge ecosystem built around it. It's the de-facto solution for so many problems nowadays. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not about PostgreSQL itself, but the fact that the major cloud providers don't keep well enough with all the latest developments Review collected by and hosted on G2.com.

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

It stores all kinds and shapes of data and lets us query it in many ways Review collected by and hosted on G2.com.

NAYAN  K.
NK
Data Scientist
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?

Simple and Easy to use. I really like the PG admin UI which is really very user friendly. Installed and Builder stack are easy to implement. Can connect with Python with ease. I use it frequently for my day to day RDBMS use. Canbe easily integrated with python. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There should be some more extensions with widely used open source software/apps. Review collected by and hosted on G2.com.

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

RDBMS Application and Easy to use PG admin UI which can be easily integrated with Python for my data science projects. Review collected by and hosted on G2.com.

CHIRADEEP B.
CB
Associate Technology
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Very easy to use and set up

PostgreSQL comes with a very easy to use UI ( User Interface ) tool like PG-Admin for every client to connect & Interact with the database.

PG Admin is very easy to use & setup with just a mouse click unlike other traditional RDBMS .

I highly recommend PostgreSQL for every client to connect & Interact, apart from MYSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such, sometimes query execution get delayed but that is very rare.

Overally its a very light-weight & user friendly tool for ervery client who want to connect with the database seamlessly.

I Review collected by and hosted on G2.com.

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

It enables me to check transcation count of every user, enables all trigger , procedures, function and other PL/SQL operation seamlessly.

It also helps to perform and execute multiple joins operation in the event of requirement of data from multiple table to retrieve the result.

Postgresql also enables aggregate function( MIN, MAX, AVG, COUNT, SUM, AVG) and views, cursor, Index. Review collected by and hosted on G2.com.

Ashwini B.
AB
Software Developer
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?

PostgreSQL is easy to use in daily development life. Developer can easily implement and integrate it into system by using gem postgres. It has different versions for operating system. It is open source relational database model and i can use it in operating system like window , ubuntu, mac ect. Most of the developer use it frequently. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When i execute large data query or complex query application stop responding. It has enormous number of users so customer support may take time to resolve query. Review collected by and hosted on G2.com.

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

Its make my devlopment process smooth. It help to store users , orders data of my application, which help me to analyze data of users. Also i can hit complex queries to fetch data. It store tremendous data into it. Review collected by and hosted on G2.com.

Aavinashh L.
AL
Manager Dashboards and Business Intelligence
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Its wonderful DBMS that has wide range of extentions and relaibiility features with great customer support Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It has one feature that needs improvement on resources useage as it uses lots of your system resources. Review collected by and hosted on G2.com.

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

Its very trusted RDBMS and give me comfort on using it for day to day operational load without getting worried. Review collected by and hosted on G2.com.

Rodrigo A.
RA
Media Activation Manager
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It's super easy to understand, implement, and adapt to any data lake. PostgreSQL has implemented many features to facilitate joint and data selections Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I can't complain about anything about postgreSQL Review collected by and hosted on G2.com.

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

Storing data, data relations, and Data Processing. Connect with Power Bi is a great feature Review collected by and hosted on G2.com.

madhusudan rao y.
MY
Vice President Of Engineering
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
(Original )Information
What do you like best about PostgreSQL?

Open Source database with a very active and passionate community.

Supports SQL and enterprise applications.

One of the best relational databases around that can be used to support various multimedia.

Very fast and able to provide access based user logins to the database Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Initial setup is not straightforward.

Getting through the very customizable options is difficult if you are just starting out. Not an easy task for a beginner to start with.

Limited GUI tools. Puts off many new users who are just starting on this journey as most of the new programmers are more habituated to a visual interface. Review collected by and hosted on G2.com.

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

Postgres was the option we chose as it has extensive support for working with JSON type and JSON blobs apart from other multimedia support.

Has a very active and passionate community supporting the project.

Documentation is very helpful. Review collected by and hosted on G2.com.

Antonio H.
AH
Consultor y CTO
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
What do you like best about PostgreSQL?

PostgreSQL allows us to manage our Dashboards generated using OLAP cubes with amazing speed and reliability. Also, its possibility of using it in Cluster format provides us with a lot of value, guaranteeing accessibility and availability of data, as well as backup copies. The beauty of this software is in the simplicity. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Very few systems can compare with PostgreSQL in my opinion (and integrated with PostGIS, it is great!). But it is true that payment systems such as SQL Server or Oracle have more configuration options, which can be useful for advanced installations. Review collected by and hosted on G2.com.

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

In certain RDMBS, when processing needs increase, real speed bottlenecks occur. With PostgreSQL this has never happened to us, and its management system is exceptional, and always with the information very accessible and displayed in a simple and intuitive way. Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
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?

Its best thing is , it is open source.

Other things i like about postgreSQL is its vast range of Data Types like JSON, Arrays, Custom data types, custom functions and operators. It gives good flexiblity.

It can handle huge amount of data, high traffic loads.

It is suitable for both large and small scale applications.

I love its command line interface.

It is easy to setup.

It can be integrated everywhere.

As it has large and active community it provides regular updates and bug fixes. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As it has wide range of feature it may take some time to learn for beginners.

Its UI tool is not that user-friendly, I rarely use it.

1 Feature they can have is distributed computing. Review collected by and hosted on G2.com.

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

PostgreSQL provides a open source RDBMS. Its open source feature benifits everyone. Also it handle huge amount of data, as it is RDBMD it is quite faster than other databases.

It offeres advanced indexing.

It provides wide range of data types and also custom data types. Review collected by and hosted on G2.com.