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 2

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.
madhusudan rao y.
MY
Vice President Of Engineering
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
Rating Updated ()
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.

Subrat  P.
SP
Project Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Rating Updated ()
What do you like best about PostgreSQL?

Postgresql is very easy to use in its pgAdmin and also in other enterprise application like DBeaver. I most like about its connectivety with clouds like AWS's RDS service etc. Best relational and open source database in term of easy to use, database recovery, backup, maintenance and its connectivety. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For beginners its initial setup complexity or the learning curve for advanced features and it's configurations little bit hard because its initial setup is not straightforword specially its port availibilty. Some user may get confused with icons of Postgresql because it may differ from MySQL, Oracle. Review collected by and hosted on G2.com.

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

PostgreSQL addresses various database challenges, offering benefits like scalability like table partitioning and built-in replication , open-source , flexibility that supports various data types , indexing methods, and procedural languages . Users find it valuable for their applications, enabling them to manage data effectively and reliably. Review collected by and hosted on G2.com.

NG
Business analyst
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic Review from User Profile
What do you like best about PostgreSQL?

PostgreSQL is very easy to use and eady to implementation but i can use cusotmer support of this tools its very frquent to use any person can easy learn and very fast way lots of features available in PostgreSQL like how to import data in very easy way and very easy to integration also customer support might be good not sure about this. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It will take some time to open and import data from CSV file Review collected by and hosted on G2.com.

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

PostgreSQL is very help to find the accurate data from data sheet like excel and provide perfect data that client required. Review collected by and hosted on G2.com.

RR
Manager
Information Technology and Services
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

PostgreSQL offers a powerful GIS extension called "PostGIS" that provides hundreds of functions for processing geometric data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL may have slower performance than other RDBMS like SQL Server and MySQL. Review collected by and hosted on G2.com.

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

PostgreSQL is known for its stability and low data corruption rate, making it suitable for large-scale applications that require high availability and uptime. It can help with business problems such as data organization, data accessibility, data security, data analysis, and compliance. Review collected by and hosted on G2.com.

ANUJ R.
AR
Technical Lead
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

Best RDBMS tool in the market. Its simple to install, configure and use. It support sql language do DDL DML operations , which supports both OLAP and OLTP workload Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing I felt. Everything is simple and easy. Review collected by and hosted on G2.com.

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

It provide database solution for my OLAP AND OLTP workload . Helps to save records in form of tables in database Review collected by and hosted on G2.com.

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

If you are finding databases alternatives to use with your env then postgresql is one of the best choice i can say.

Because it provides a robust and powerful architecture. Anybody want to start to have the knowledge of databases then i can say use the postgresql so that you will have the lots of think clear in your mind and also by passing sometime you definetily love the postgresql database. Quering to postgresql is very much simple and anybody can understand. there are lot to add but you should use postgresql. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes launching pg admin takes sometime. Review collected by and hosted on G2.com.

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

It has ighly reliable RDMS and its opensource so anybody can use it for free. Also it has high transaction speed and fast data aggregation. Also quering to postgres is much simpler. Review collected by and hosted on G2.com.

Henry C.
HC
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 think it is really well documented, you can find lots of free tutorials en webpages and youtube. You can configure it to fit your requirements.

It also has a lot of functionalities, I think it is one of the most advanced databases available right now.

You can integrate PostgreSQL with a lot of different tools, and it provides great advantages for your use. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It can be a little tricky for starters, because the inital configuration can be a little cumbersome, but I think it is not a big deal since you have support online where you can find a lot of tutorials. Review collected by and hosted on G2.com.

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

Some of our databases are running using PostgresSQL as engine. We use them through RDS in AWS. Review collected by and hosted on G2.com.

Shwetank S.
SS
Software Engineer
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?

postgresql is highly secured.it has SSL certificates for encrypted connections which tells us how secure is it. you can give the accesss basd on role and define the custom rules.i like the perfomance of it in terms of how fast it is it provides you the facilities like indexing, query optimisation etc. so performance wise its beating its competitors in the market. its reliable and stable many companies use this in the production which tells us the trust of companies on its security aspects.its easy to use as a beginner anyone can understand it easily. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

its setp and configurations are little bit complex.when you will trigger big queries it occupies larges space so its kind of resource intensive so you may see sometimes performance scaling becomes the major concern. Review collected by and hosted on G2.com.

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

i work as a full-stack developer so i use postrgesql for storing and fetching the data throun api's which i create for my full-stack application Review collected by and hosted on G2.com.