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 54

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.
Rickert M.
RM
Software Developer
Information Technology and Services
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?

I love the large feature set built into Postgres. In particular, range queries are a godsend for time-based applications. Full-text search functionality means I don't have to bother with an elastic search installation. There is also much additional functionality that can be gained via extensions such as postgis. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Replication can be a pain to configure compared to other DBs. Hosted solutions like RDS takes care of this though. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If regulations require you to encrypt data at rest, Postgres might be problematic. Postgres does not support database level encryption out of the box. Encryption at rest could possibly be achieved via full disk encryption. You can get this on medium sized RDS instances on Amazon. Otherwise, there is an extension for row level encryption. Review collected by and hosted on G2.com.

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

I used Postgres for a scheduling web app. Because range queries are built in, it's a lot less effort to query compared to MySQL. It's also more efficient. I also use the full-text search functionality for our built-in knowledge base, as well as the trgm extension to order search results. Review collected by and hosted on G2.com.

Zhanbolat A.
ZA
Application Development Engineer
Internet
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The software can be extended. I like its compatibility with different OSs. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

UI could be improved to make it more user friendly Review collected by and hosted on G2.com.

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

Database management Review collected by and hosted on G2.com.

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

Great tool for relational database with additional functionality then sql Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some of the query are not as same as sql. It would be nice to make it same language Review collected by and hosted on G2.com.

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

Used to develop software. From Dev stand point, it’s easy to control and manipulate and faster then sql server or MySQL Review collected by and hosted on G2.com.

Verified User in Financial Services
UF
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Vacuum feature is the best. Reasonably fast for medium enterprise development. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Could get really challenging with a huge data deployment and multi data center deployment. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Any enterprise development which does not require huge data needs and replication. Review collected by and hosted on G2.com.

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

Enterprise java j2ee development Review collected by and hosted on G2.com.

Pascaline I.
PI
R&D intern
Computer Software
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 Gives Campaign
Incentivized Review
What do you like best about PostgreSQL?

It is very easy to create scripts.Moreover, it provides users with more functionalities. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it took long to connect to the database. Review collected by and hosted on G2.com.

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

Storing the customer intelligence data 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
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

CTEs – Common Table Expressions - which allow us to do awesome things like recursive queries but even the most simple form of them. A nice feature that we can easily achive Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its replication was implemented at the storage engine level, that makes it bit expensive interms of reoplication Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Implements the SQL standard very well and supports lots of advanced data types, inclusing multi-dimensional arrays, user-defined types, etc. Review collected by and hosted on G2.com.

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

SMALL query based tables Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
II
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I use the free version and like the fact that it provides almost all the relational features like oracle db Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Required a bit of learning to adjust and its always good to include that in your timeline Review collected by and hosted on G2.com.

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

Good to use with Kickstarter projects before support becomes an issue. 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
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It’s very cost effective and it has extension to GIS which is great. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It does not have AWR report that is helpful in finding all queries that are getting executed . Also when you delete lot of record it create vacuum . Review collected by and hosted on G2.com.

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

We have GIS related data processing Review collected by and hosted on G2.com.

Verified User in Non-Profit Organization Management
AN
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Great tool for both learning and production! No major issues, straightforward and easy to use. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I can't think of anything in particular that I did not like. You really need to know what you are doing to use this product, but that's about it. Review collected by and hosted on G2.com.

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

Creating my own version of our gui database for my data analysis use. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I like how it has tables and also how it has columns Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't like how there are no good clients that let you see images directly in the viewer Review collected by and hosted on G2.com.

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

We're storing and keeping our data secure Review collected by and hosted on G2.com.