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 35

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
Small-Business (50 or fewer emp.)
"Hard to maintain"
What do you like best about PostgreSQL?

Postgres has a good performance an many features Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres has a bad backwords compability, Review collected by and hosted on G2.com.

Verified User in Computer Software
CC
Enterprise (> 1000 emp.)
"Great open source database"
What do you like best about PostgreSQL?

Open source and great support from the community

Fast and excellent performance for database operations

easy to integrate with other applications(ETL/web apps)

Reliable and easy to maintain. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

although pgadmin is great interface for postgres, it freezes at times when running complex queries or queries returning large dataset.

Writing complex queries can be difficult Review collected by and hosted on G2.com.

Verified User in Government Administration
UG
Enterprise (> 1000 emp.)
"Postgres - Not that greaat, but it is free"
What do you like best about PostgreSQL?

Not much other than the price. Supported SQ Syntax is similar to Oracle PLSQL Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

the GUI's /tools are garbage, support is lacking, hard to interface with other appications Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Small-Business (50 or fewer emp.)
"Essential!"
What do you like best about PostgreSQL?

- Very easy-to-use graphical interface for carrying out all kinds of tasks.

- Allows table joining.

- Better performance the larger the database. It adjusts to the available hardware.

- Free, open-source. Cross-platform.

- Large community of developers. They provide excellent technical support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Not advisable for small databases, although they also have acceptable performance.

- The configuration takes time. Less intuitive than MySQL. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
CI
Small-Business (50 or fewer emp.)
"built-n procedural extensions and lightweight posgres"
What do you like best about PostgreSQL?

postgres is lightweight and easy to install/reinstall development version in local system,

optimization techniques are different using Query planner/Optimizer and analyze, explain. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Difficult to maintain Transaction control in stored procedures like start/begin and end transaction and commit in between execution. for Large data volume like 20-50~ million, giving performance issue even required a lot of table partition/correctly setting up indexes and was required more query optimization Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Small-Business (50 or fewer emp.)
"Postgres is amazing and has a great community"
What do you like best about PostgreSQL?

I love the community around postgres. There are so many great enhancements that they make and the features that you get are fantastic considering the price. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I wish there was more commercial support for community plugins and extensions. Review collected by and hosted on G2.com.

Carlos Alberto P.
CP
Especialista de Desarrollo
Mid-Market (51-1000 emp.)
"The most efficient relational database manager"
What do you like best about PostgreSQL?

Postgresql is by far the most efficient database manager, this is based on the selection algorithm used in order to determine the fastest route and with the least use of equipment resources, in addition to the effectiveness of the results shown. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There are few things to say negative postgresql however its response time to very simple queries is not as efficient as others in its style, it should be used when the power of its core is required for simple consultations is a waste of resources Review collected by and hosted on G2.com.

Maria L.
ML
Specialista IT
Small-Business (50 or fewer emp.)
"The definitive DB you need"
What do you like best about PostgreSQL?

- Its free and open Source!

- Transactional support for schema migration,

- Large variety of custom functionality and plugin,

- Great overall performance - perfect for system with low hardware specs - it is light and well optimized

Huge community with a great support Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Backup and Restore of large DB are a bit slow, with some significant performance gap compared with other DB

- Not very User Friendly for new users or for those who are used to using paid software

- The absence of the possibility of the clustering is essential for us, and we must therefore rely on a third part software. Review collected by and hosted on G2.com.

Verified User in Media Production
IM
Mid-Market (51-1000 emp.)
"Pretty Easy to Use"
What do you like best about PostgreSQL?

It is pretty easy to use and there are a lot of ORM frameworks on top of it to help Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A bit slow sometimes which is an issue. If you have SQL knowledge then sometimes it is bit different from sql so creates confusion Review collected by and hosted on G2.com.

Verified User in Computer & Network Security
AC
Mid-Market (51-1000 emp.)
"Postgresql is best"
What do you like best about PostgreSQL?

Postgresql is best oltp db and we use greenplum on top of postgresql very useful Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't find any dislike about postgresql 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