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 51

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

The product is very similar to the large scale

Brand name product. It functions and works the same and does not Cost nearly as much. If you know SQL, the slight variations on la gauge from MSSQL will be no issue at all. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There was a small learning curve due to some language structure changes. But nothing that is difficult. Review collected by and hosted on G2.com.

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

Database access, querying and reporting Review collected by and hosted on G2.com.

Terence F.
TF
Enterprise Development Manager
Utilities
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?

It's open source software and a large community that supports the incredible features that the database offers Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing yet! Replication could be improved Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Do a cost / benefit analysis - this is fundamental for any new customer engagement solution that uses your product. A database is the core of any software application and you must understand and search out the issues and requirements that face the customer. Every implementation is unique and needs to be looked at holistically - architecture, security, performance, disaster recovery, reliability etc Review collected by and hosted on G2.com.

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

Most solutions do not need a heavy-weight database like Oracle or MS SQL; PostgreSQL offers a very convenient and powerful database that pack a lot of features. Review collected by and hosted on G2.com.

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

Uses a large subset of standard SQL. Transactional and enterprise-ready. Used a lot, by a lot of companies and people; any problem you have has probably already been solved. Should be familiar to anyone familiar with any other SQL-based RDBMS Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Esoteric management commands like \du are weird and hard to remember. Review collected by and hosted on G2.com.

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

Backend for web and mobile app Review collected by and hosted on G2.com.

David H.
DH
Network Engineer
Legal Services
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

very flexible, good community behind it supporting each other, lots of web resources. Small footprint Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It was an adjustment to all CLI Linux database as I'm not a DBA but it was worth figuring out. Review collected by and hosted on G2.com.

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

Local database that was application specific that could eventually be clustered if desired. Review collected by and hosted on G2.com.

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

BD graphic design and management tools, good scalability since it is able to adjust to the number of CPUs and the amount of available memory optimally Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lack of robustness for high availability Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Be very careful with security levels Review collected by and hosted on G2.com.

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

Our technological palataforma is different flavors and has helped us to operate on different platforms, including Linux, Windows, Unix, Solaris. Review collected by and hosted on G2.com.

Laveena B.
LB
Graduate Services Assistant (Part-time)
Higher Education
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Query optimization time and flexibility. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Complex to understand and tough installation in Ubuntu. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Yes Review collected by and hosted on G2.com.

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

Database and learning purpose. Review collected by and hosted on G2.com.

Verified User in Internet
AI
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 amount of updates, and support by the community is amazing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing in particular, only that replication could take a page out of mysql. Review collected by and hosted on G2.com.

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

Our entire BI database is primarily on Postgresql, it is easy to maintain and does not require a lot of resources to run an efficient database. Review collected by and hosted on G2.com.

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

Used PostgreSQL for more than 4 years on 2 different jobs. Convenient and easy to learn. All main stream functionalities are there. No fancy add-ons. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When I used the software it did not support tabbed query editor, so I had to switch query windows fairly frequently, adding a little difficulty to use. Now I guess they must have changed. Review collected by and hosted on G2.com.

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

Exploring relational database - designing reports and downloading data for modeling purposes. The benefits included easy access to database and easy to manipulate intermediate results. Review collected by and hosted on G2.com.

Julio Rafael R.
JR
Analyst and Software Developer
Program Development
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

after version 9.6 you can use "on conflict" functions to handle PK conflicts Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PG Admin is to slow... but nothing to worry about. Review collected by and hosted on G2.com.

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

in marketing data the volume of data is huge .. but for PG is nothing Review collected by and hosted on G2.com.

Jonathan G.
JG
System Architect
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It has a lot of integrations with products we use Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Editing existing data and modifying existing settings isn't as easy as other platforms in my opinion Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

After switching to PostgreSQL, we realized there weren't really many amazing benefits over staying with a DB tech we were already familiar with. We still experienced bugs and had to run DB update scripts etc. It was just a little difficult because it was new to us then. Review collected by and hosted on G2.com.

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

We use many Atlassian products which recommend using PostgreSQL for their backend, so that's why we're using this. Review collected by and hosted on G2.com.