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 18

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.
Verified User in Airlines/Aviation
UA
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Felt organized, easy to understand and to use. Could keep several databases within eyes reach Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Occasional technical glitches, brief learning curve before becoming fluent with their system Review collected by and hosted on G2.com.

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

Being able to use SQL to find business solutions and automatically store useful data in a database Review collected by and hosted on G2.com.

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

Posgress is very light and flexible compared to mysql Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Do not have much documentation to start with Review collected by and hosted on G2.com.

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

Started to integrate our backend system with postgres Review collected by and hosted on G2.com.

AF
sql
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
Verified User in Retail
UR
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

The great performance on top of the traditional DB ability to have a json data type really helps keep within the realm of SQL while creating a solid backend for microservices. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It has a little bit of learning curve but not necessarily anything bad I would say about postgresql Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are not ready to go towards nosql but want the flexibility of it while maintaining traditional SQL, then postgresql is the way to go! Review collected by and hosted on G2.com.

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

Using as backend for application specific data, with a lot of the data being stored as json in order to interact with apis Review collected by and hosted on G2.com.

Alexandr V.
AV
A
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

A lot of features, smart backup, PG cluster ability, production ready DB Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Troubleshooting something hard to do, poor out of the box documentation Review collected by and hosted on G2.com.

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

SQL database help to org data Review collected by and hosted on G2.com.

Ajay S.
AS
System Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

1) It can handle large amount of data securely without much difficulty.

2) It is secure.

3) It handles complex queries smoothly.

4) Creating and running Stored Procedures are easy and is handled without any issue.

5) Good to store large amount of structured data.

6) Provides some inbuilt data types to make working with data easier.

7) Many cloud platform like aws and azure supports PostgreSql.

8) Open source and free. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

1) Sometimes while creating connection it takes time.

2) Somewhat slow when you perform large data operations like updating and inserting.

3) Not very easy for beginners. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are looking for free relational Database then this is it. Only thing you need to think about is that it is somewhat slower during large data set operation as 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?

Used it for storing and performing operations on large amount of structured data. As it is open source and free it comes with no cost and perform its job perfectly. Only issue is while performing operation on large set at a time it is somewhat slow. Review collected by and hosted on G2.com.

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

The performance of the database is topnotch relating to transactions, concurrency and schema controls Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is diffcult to resolve issues/errors as a lot of documentation is not available around this Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

There are a lot of tools for coverting other SQL scripts to prostgreSQL scripts. So if you are looking to switch it's not that diffcult. Also it will significantly reduce your cost Review collected by and hosted on G2.com.

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

We tried to find a low cost alternative db system for a client. So we moved from Oracle to prostgreSQL. This brought the cost down substantially Review collected by and hosted on G2.com.

Syed  M.
SM
Associate Consultant - (Data Engineering)
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

Free , Easy to connect over network has many features and Functions and Fast compared to MySql , Support from Large Community . Can have number of parallel users . Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

We need to have aliases for sub-queries which is an overhead sometimes when migrating from different database . Review collected by and hosted on G2.com.

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

I am Using it for practice and to store my Personal Projects in postgresql .

Also worked with Aurora (postgresql) for some project . Review collected by and hosted on G2.com.

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

The cost point on PostgreSQL is significantly better than the big guns like Oracle. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't think this is as redundant a solution or as high capacity as other databases. Review collected by and hosted on G2.com.

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

I wouldn't say that we're solving problems with it, but it met our need for a database at reduced cost. 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
Verified Current User
Review source: Organic
Rating Updated ()
What do you like best about PostgreSQL?

It's great enterprise sql quality database. Postgres better implements a lot of things in an open source as compared to Oracle. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Installation is confusing as compared to MySql. Has a lot of prerequisites. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

None Review collected by and hosted on G2.com.

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

I use Postgresql everyday especially for data analysis. It's easily gets compatible with Microsoft Visual Studio. It also three temporary tables to store large queries. You can also temporary tables into locan and global.

Postgres saves history of previous queries which is pretty useful. Review collected by and hosted on G2.com.