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 39

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
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.

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Product Avatar Image

Have you used PostgreSQL before?

Answer a few questions to help the PostgreSQL community

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.
Paola S.
PS
Experto de Productos y Segmentos I
Small-Business (50 or fewer emp.)
"It is a good manager of data bases oriented to objects, it is open source"
What do you like best about PostgreSQL?

The speed is maintained when managing small and large databases, its installation is unlimited, it is low cost of operation in maintenance and adjustment, it is multiplatform, it is stable during the use of databases, it operates on different Linux web platforms, Window, MacOs X, has an excellent security system (user and passwords), large storage capacity Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is slow in incersiones and updates, it has online support but it is not official Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Enterprise (> 1000 emp.)
"PostgreSQL Review as a Developer"
What do you like best about PostgreSQL?

It is Open source so free to use and install Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing much but PostgreSQL tool UI is not user friendly Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Enterprise (> 1000 emp.)
"Great product for many use cases"
What do you like best about PostgreSQL?

I have used it for extremely small projects, and extremely large projects. The ability to drill down in the config to make sure to use resources carefully or the ability to just get it working has been really convenient. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is a pretty good learning curve to be able to become very proficient with it. Review collected by and hosted on G2.com.

Mehmet James B.
MB
Business Intelligence Manager
Small-Business (50 or fewer emp.)
"Wonders with Postgre"
What do you like best about PostgreSQL?

This is a great database that I just met and it is super reliable, fast, and easy to maintain. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I wish it has a better query editor that enables formatting of the queries as well as ease on execution. Review collected by and hosted on G2.com.

Verified User in Internet
UI
Small-Business (50 or fewer emp.)
"Postgres is a good replacement for expensive Oracle."
What do you like best about PostgreSQL?

I like the Sequence that can be declared for each table, similar to Oracle DB.

90 % syntax and features of Oracle does match with Postgre Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing, it is proven to be production ready Review collected by and hosted on G2.com.

Verified User in Entertainment
AE
Small-Business (50 or fewer emp.)
"Postgres is the best relational database"
What do you like best about PostgreSQL?

Built in functions: pg_cron, levenshtein, ease of timestamp/interval manipulation Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Adding constraints in Postgres is less straightforward than in vanilla SQL Review collected by and hosted on G2.com.

Tomas D.
TD
Vice President
Mid-Market (51-1000 emp.)
"great database with easy and robust backup and recovery"
What do you like best about PostgreSQL?

The way how easy it is to customize the database to suit your needs.

One can use DB Protection for PostgreSQL using IBM Spectrum Protect to have a very efficient and fast backup as it o my backup changes in the database.

Https://ligtas.org

ANSI SQL complaint.

Easy to migrate Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The way how the transaction logs are handled can be problematic especially during a recovery if you perform that multiple times Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care
UH
Mid-Market (51-1000 emp.)
"Small learning curve if you know SQL"
What do you like best about PostgreSQL?

I liked that it is an open source program and that there is a small learning curve if you already know SQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't like that there is no way to report errors, so there's no way to track bugs or fixes. Review collected by and hosted on G2.com.

Ross M.
RM
Corporate GIS Data Coordinator
Government Relations
Enterprise (> 1000 emp.)
"PostgreSQL - the heart of our GIS"
What do you like best about PostgreSQL?

PostgreSQL with PostGIS and pgRouting offers us a flexible, robust and reliable open source database platform on which to build the rest of our GIS infrastructure. The open source license gives us the freedom to install and use it as we like. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If I had my way I would switch out all our other RDBMS for PostgreSQL. Review collected by and hosted on G2.com.

Denish P.
DP
LinkedIn Learning Instructor
Small-Business (50 or fewer emp.)
"The best open source database product "
What do you like best about PostgreSQL?

Postgres can be used as multi-model database

- RDBMS

- Document store

- Search Engine

- Geo spatial database

- Key-value store

- JSONB Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lack of mature GUI tools

Built in sharding support Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
PostgreSQL