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 47

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.
Verified User in Information Technology and Services
AI
Mid-Market (51-1000 emp.)
"Great open source DB"
What do you like best about PostgreSQL?

I like that the DB is free to use and distribute, however there are tons of resources available for the product. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The only thing i can think of that i currently dislike is running a query on several databases at one time. something that is actually much simpler in SQL server. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Great tool for database queries"
What do you like best about PostgreSQL?

Faster execution time, easer to remember syntax, takes less memory space after intsallation. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

i dont dislike anything about thsi tool. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
CI
Mid-Market (51-1000 emp.)
"Open Source DB which is equivalent to Oracle DB"
What do you like best about PostgreSQL?

Almost all features / objects including Materialised views, Views, Functions, Procedures, etc., in Oracle DB are available in it and it is open source so no need to pay any licence cost for the database, conversion tool / plugin is available to migrate data from Oracle DB to PostgreSQL. With few syntax errors entire oracle database can be migrated to PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

SQL editor is not good, it doesn't have SQL beautifier and other good productivity options. It should be improved similar to PL/SQL developer or Oracle SQL developer tool. Some of the objects / concepts - Sequence, Joins with (+) symbol, ROWNUM, SYSDATE, etc., in Oracle are not available in PostgreSQL. Review collected by and hosted on G2.com.

Francis Jayson S.
FS
Independent Consultant
Management Consulting
Small-Business (50 or fewer emp.)
"PosgreSQL Effectiveness Review"
What do you like best about PostgreSQL?

What we like best of PostgreSQL is the versatility, community support and ease of adaptability Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

None - There was none to dislike PostgreSQL at all. Its fantastic! Review collected by and hosted on G2.com.

Chethan M.
CM
Technology Lead
Enterprise (> 1000 emp.)
"Review on Postgres"
What do you like best about PostgreSQL?

PostgreSQL is the SQL DB and been gaining popularity in the recent years. Today, After MySQL acquisition the community and many organisations do not consider MySQL though its popular and one of best. The next best is PostgreSQL also because of its good performance results. PostgreSQL is implements SQL standards very well and it supports advanced SQL stuff. As PostgreSQL is Open source, its been preferred by larger community and even few ECM tools Like Nuxeo ECM recommends best results. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is not very easy to understand or use unlike MySQL, it requires a little learning curve for new folks. The initial installation also requires some background and will take time for first few installations or integrations with other tools. Review collected by and hosted on G2.com.

Verified User in Airlines/Aviation
EA
Small-Business (50 or fewer emp.)
"Great DB"
What do you like best about PostgreSQL?

It is very quick and reliable, and secure Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing to dislike so far, i hope it will remain the same Review collected by and hosted on G2.com.

Verified User in Internet
II
Enterprise (> 1000 emp.)
"I love SQL"
What do you like best about PostgreSQL?

I love that writing in SQL is so similar to writing in English. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Managing date variables can be somewhat difficult. Review collected by and hosted on G2.com.

Verified User in Financial Services
UF
Mid-Market (51-1000 emp.)
"PostgreSQL > MySQL"
What do you like best about PostgreSQL?

The query capacity of PostgreSQL is superior to MySQL which is what I was using before switching over the PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Whenever you are switching querying languages there are always different querying nuances that can cause differences in what type of queries you are able to easily transfer over between languages and what changes you need to change in order to maintain efficiency and consistency. Review collected by and hosted on G2.com.

Danylo H.
DH
DevOps/AS3/C++ Developer
Entertainment
Small-Business (50 or fewer emp.)
"A mature database management system"
What do you like best about PostgreSQL?

- very stable

- featurerich configuration, supports reconfiguring on fly

- lots of plugins (extensions)

- improving with each release

- ACID

- self-heal on start

- popular

- allows continuous backup and replication

- fast queries

- extended SQL (PG/SQL)

- fast restart

- has alot of GUI tools, has tuner program Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- had problems with WALs filling up disk space. After disk space is full, it is hard to start service - simply removing extra WAL files can make DB corrupt. So there should always be a method to quickly create free space on disk partition

- some configuration options can't be reconfigured on a fly (max_connections, listen_addresses)

- may be problematic to install on Windows (it involves creating dedicated user `postgres`, automatic, but our colleagues had problems with reinstalling)

- had problems with removing tablespaces

- had problems with table and index bloat (autovacuum not helping), requires periodic maintenance

- Review collected by and hosted on G2.com.

Alexander C.
AC
IT Analyst
Retail
Enterprise (> 1000 emp.)
"Tough but easy"
What do you like best about PostgreSQL?

I like that it comes with all of the sql commands built in to the CLI. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I disliked how hard it were to get up and running. 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