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 10

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.
Or N.
ON
Data Engineer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Fast, lean has all the functions you need to work with a DB. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Everything is working fine so far. if there will be a change I will update Review collected by and hosted on G2.com.

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

Fast and lean DB for our Microservices transition Review collected by and hosted on G2.com.

Swetank S.
SS
Lead Associate
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

Best thing is its very easy to use and its training and support is easily available as one SQL language works same for almost all databases. If we know the tool well then sql knowledge is not much required. Also knolwedge of sql can be used in any databases. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

This tool is not used by many people which makes it hard to share file or databases with others. Compared to ssms its not have that much features and creating keys are also hard. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you want database which is free of cost and ease of use then go for it. A person not knowing sql also can work on this tool. Review collected by and hosted on G2.com.

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

With basic training all my colleague are easily using this software for database. Plus this software is available at free of cost which makes it accessible for all. Review collected by and hosted on G2.com.

Nitesh K.
NK
Project Associate(II)
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 a Secure, robust, and reliable database. It is an open-source RDBMS having great performance to handle a large amount of data. PostgreSQL can be installed on windows as well as Linux operating systems. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL requires training for the beginner. It is managed by using a graphical tool through PgAdmin. Sometimes it is a little bit slow on executing queries on a large database. Installing PostgreSQL should be more User-friendly. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Open Source RDBMS which can handle large databases. It is robust and secure. Just go with it. Review collected by and hosted on G2.com.

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

PostgreSQL is an open-source RDBMS, I can use for various applications that will save the cost of the organization. It supports various datastore features like JSON etc and is easy to integrate with other applications, which saves time and effort. Review collected by and hosted on G2.com.

Yash C.
YC
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?

The thing which I like the most about PostgreSQL is it supports a wider variety of data types as compared to the others and it is also completely free to use and it also supports data warehousing Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The thing which I like the most about PostgreSQL is it is slower while reading the data from the database compared to others. Review collected by and hosted on G2.com.

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

With PostgreSQL, it is easier to perform the write operations on the database effectively and also it handles the concurrency better as compared to others. Review collected by and hosted on G2.com.

Mashmuma Q.
MQ
Lead Data Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

PostgreSQL is a good option as an object-related database since it's free it is very convenient for us to request management to use it. One can use it for data storage and analysis both. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some features are missing which we can find in other database systems.

If I compare MYSQL and PostgreSQL in terms of optimization help through explain plan than MYSQL provides a more readable way than Postgre, after reading the MYSQL plan one can change its query to optimize it very easily while it's a bit difficult in Postgre explain plan. Review collected by and hosted on G2.com.

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

I'm using it for data storage and data analysis both. Review collected by and hosted on G2.com.

Abhishek J.
AJ
Jr. Full Stack Developer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is a regional database management system which stores the structure data.

Query execution speed is fast which helps to make over-all performance of the application fast.

Backups and restoration process is very easy.

It is secure, reliable and robust. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it takes lot of time to execute complex quries.

Installation process is little heavy as compare to other SQL databases.

User interface can be improved. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Best for structured data. Review collected by and hosted on G2.com.

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

I am using PostgreSQL for storing large amount of relation data.

As it is object relational database it is very easy to perform operations like insert and select.

Also it's performance and responce time is very good.

It has strong comunity support. Review collected by and hosted on G2.com.

Manu V.
MV
Senoir Software 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 thing I like most about PostgreSQL is that it has a dedicated database connection for all the fremwork. PostgreSQL has a reliable dependency for spring boot. It makes it easy to connect PostgreSQL to the backend and perform various operations through coding. When you compare it with other alternatives, it offers many features and, most importantly, provides up-to-date security. One more thing I like about PostgreSQL is its large support community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

To perform database-related tasks, you must have proper knowledge of PostgreSQL documentation. For fresher, it will be challenging to understand complex things in the documentation. One thing I noticed while using PostgreSQL was it becomes slow while handling huge transactions. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is one of the top 5 RDBMS available in the market. It is a common database among developers, and it is easy to set up and configure. I will recommend others to try this product. Review collected by and hosted on G2.com.

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

I use PostgreSQL as part of my spring boot project. My project uses PostgreSQL as well as CouchDB for storage purposes. PostgreSQL makes it easy for me to integrate with spring boot because of the PostgreSQL database connector and also supports spring JPA to perform fetching-related tasks. Review collected by and hosted on G2.com.

Oscar C.
OC
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?

How robust is postgres and how extensible it is. Despite being a database with lots of years in the market, it is up to date with the latest needs (for instance working with JSON data) Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing. Maybe the fact that mysql gets more popularity despite not being as robust as postgres Review collected by and hosted on G2.com.

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

Basically to use it as a relational data storage for our microservices layer here at Pager Review collected by and hosted on G2.com.

Kushal V.
KV
Senior System Engineer - BI developer
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?

Easy to build connection between postgreSql to other framework. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I feel the interface could be better. It took little time to open pgadmin. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It's open source. easy to run complex queries. Faster execution Review collected by and hosted on G2.com.

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

You can load any excel file format and play around it.

You can create your own DB in your laptop using this PG admin. Review collected by and hosted on G2.com.

Krishna Prasad J.
KJ
Talend Developer
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 Nature

--> Easy to use and well-defined documentation and lots of tutorials for quick and fast learning

--> Comparable with Oracle Database System

--> Almost all features are available freely. You do not need any other database system if you use postgres. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Absolute beginners can feel difficulty learning and implementing it in real-time projects. Basic knowledge of database management systems is a must to learn any DBMS Software. Review collected by and hosted on G2.com.

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

I use it in real-time projects such as designing database systems for E-Commerce Applications, and I mainly use it along with Node JS and Angular. I do not have to pay any amount I had to pay if I had used SQL Server OR Oracle Software. Review collected by and hosted on G2.com.