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 23

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

AK
Akshaya K.Small-Business (50 or fewer emp.)
5.0 out of 5
"i am using this as my database since 2024 i love this product"
we can automatically create a ER diagram of a databse with 2-3 clicks . its very easy install in my system the storage was very low and easy to in...
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...

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

638 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.
638 PostgreSQL Reviews
4.4 out of 5
638 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.
SW
Software Engineer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is one of the best choice when it comes to managing relational databases and it is available to use for free! It provides an ease of use to its users. It allows developers the freedom of using many languages eg. Python for scripting. It works well with large amount of data too. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Processing big data is need of the day and very much required in all businesses. Even though postgreSQL can support large databases, It is not suitable for big data due to large computation time. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

A very useful application to manage databases. Available for free along with good support. Review collected by and hosted on G2.com.

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

I use postgreSQL to manage out employee and project databases. Its ease of use the fact that it is available for free make it possible for us to use it for small scale businesses and needs. Review collected by and hosted on G2.com.

eleomar d.
ED
Reviews sobre sistema operativo windows 7
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
Translated Using AI
What do you like best about PostgreSQL?

I like the way it manages the database and connectivity, and the version is free and unlimited. It is stable and reliable, very secure.

Very secure when storing information and stable on different operating systems. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

it does not have online or phone support but rather a forum where your questions will be answered.

it tends to be slow in insertion and updating in low-volume databases, it is oriented towards databases with large storage capacity. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

it is a good tool for managing large-scale databases as it fails with databases with little information but I recommend it because I use it for my information system and I have good control over them

it is a complete database manager with multiple tools that will not be useful when configuring, creating, and registering different types of data; it also has multiple security and encryption services that demonstrate to the user that their information is safe and reliable

effective for databases that handle large volumes of information Review collected by and hosted on G2.com.

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

connect some operating systems with a single secure, reliable, and free database manager

storage of information in a secure and fast way previously there was a lot of information loss since the old database managers failed or had information loss Review collected by and hosted on G2.com.

Verified User in Entertainment
UE
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 allows us to easily run queries and cross-reference information from various tables of data we have stored. As a subscription-based service with millions of user emails and information, this is extremely important. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

While simple for someone who knows SQL there is a learning curve. It would be amazing if PostgreSQL allowed for easy implementation of a UI that was friendly to those who are not familiar with the coding behind queries to run searches in order to pull information from various sources. Review collected by and hosted on G2.com.

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

We are able to search our information for potential abuse by users, as well as find accounts that may have been impacted by a bug in our system and mass resolve issues. More recently as we migrated billing systems some accounts had fallen through the cracks and were not billed in a few months. We were able to use PostgreSQL to write a query in order to find those accounts and bill them going forward. Review collected by and hosted on G2.com.

MD
CTO
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?

Postgres is an incredibly stable database workhorse. It handles production traffic with ease, and its default settings are generally very stable and scalable. It links easily to all sorts of ETL tools and supports all major ORM libraries. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Well, just like any SQL database, by default it's not vertically scalable. So once you can't upgrade your database server hardware further, you sort of hit a cap, until you put in sharding logic. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Realize that, if you're going to use this for production, you need DB experts on your team, even if you're getting postgres from AWS or from Heroku Review collected by and hosted on G2.com.

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

Running our business and powering our website Review collected by and hosted on G2.com.

Ahmadou N.
AN
Soccer Referee
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I pretty much enjoy the elastic factor in its design and implementation. Offers a huge deal with data storage and security. As compared to MySQL and other database systems, PostGresSQL stands out as the go-to database when it comes to data redundancy and better maintenance.

The pricing is not bad either and cloud solutions providers offer great supports. I should know, I use them whenever I need. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The setup is not that easy mostly on the Linux environment. The user has to have a better knowledge about the installation and usage before engaging on this database choice but it is worthy to spend time and energy learning. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are looking for a database that offer more tools as compared to the general SQL you are used to, try PostGresSQL, I guarantee you will never look back Review collected by and hosted on G2.com.

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

Data storage and maintenance.

It is the database of choice when it comes to cloud storage and I use it mostly from Heroku and Amazon ASW platforms Review collected by and hosted on G2.com.

Verified User in Education Management
UE
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 server has the advantage of having the security features of a paid service database, and the features of an open source database such as contact support, strong customer base which makes the service unique. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There are few technical glitches while trying to login using PostgreSQL server, because of this issue I had to uninstall the application multiple times to login into the server. It also has a problem regarding the duplication and restoring the database. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

This PostgreSQL server is advantageous for performing the data analysis directly from the database, this product has a good security feature with a very inexpensive price for the customers. This is what makes the PostgreSQL server advantageous. Review collected by and hosted on G2.com.

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

I have used the PostgreSQL server to store the data required for performing the data analysis. The advantage of using SQL server is I can automate the data wrangling and ingestion process by connecting through the application programming interface using python for PostgreSQL (psycopg2) package. Review collected by and hosted on G2.com.

EW
Database Administrator
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Postgres is very stable. Borrows some features from both relational database systems and NoSQL databases giving it very complex and powerful hybrid features. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Although postgres has been growing recently, it is not easy to find a professional who is well trained in postgres compared to other more popular DBMS like MySQL, Microsoft SQL and Oracle Review collected by and hosted on G2.com.

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

Postgres has table inheritance, a feature that in not implemented by other relational DBMS Review collected by and hosted on G2.com.

DG
Software Engineer
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?

The simple GUI, combined with the CLI commands - makes this database very easy to use. Additionally, the fact that it is open-source and powerful makes it a go-to database for everyone. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

No dislikes as of now. PostgreSQL being such a good open-source database, one would have to nit-pick really hard to find out something. Review collected by and hosted on G2.com.

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

Accessing the database while it is being hosted in a server from different machines. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
CI
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?

Good open source database that implements the SQL standard. Very easy to administer, and standard SQL works well with it. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Their internal database commands in psql are a little confusing at times. Commands like \d \d+ etc. QL Review collected by and hosted on G2.com.

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

Using it as our database for all SQL work, and very easy to get set up and use. The open source version has a lot of flexibility. Review collected by and hosted on G2.com.

Yuriy P.
YP
Senior Software Engineer (Blockchains Infrastructure) @ Fireblocks
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Open source.

Huge plug-ins offerings.

Great documentation. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Less known than MySql for example.

Less used by enterprise companies,

No official support representative for solving problems. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Good choice for relational DB, with transactions. Review collected by and hosted on G2.com.

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

Storing relational data, transactive operations. Complex queries. Review collected by and hosted on G2.com.