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

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 Information Technology and Services
AI
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

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

storing data Review collected by and hosted on G2.com.

Verified User in Computer Software
CC
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

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

we used postgersql to store all our data for our analytical projects. Reporting applications were extracting data from postgresql database. Review collected by and hosted on G2.com.

Verified User in Government Administration
UG
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
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.

Recommendations to others considering PostgreSQL:

No Review collected by and hosted on G2.com.

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

JDBC connectivity to applications, using tools such as PGAdmin Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Translated Using AI
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.

Recommendations to others considering PostgreSQL:

Excellent tools for managing a database and getting the most out of a simple one from its interface. Review collected by and hosted on G2.com.

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

The ability to store and manage a large database consistently and effectively, with great performance advantages, which ensures optimal access to information. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
CI
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

Recommendations to others considering PostgreSQL:

If you want to know cost of each query then it provide great Query planner/Optimizer using analyze, explain. Configuration management can very easily done using a few files like pg_hba.conf and postgresql.conf but it is very tricky based on your data volume.Like cache memory ,configuring (auto)vacuum Review collected by and hosted on G2.com.

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

Business preferred to use Postgres because it support major cloud technology. PL/SQL is much more mature technology than any of the PostgreSQL procedural extensions. JSON support allows for Postgres to transfer data as raw text and without attributes and markup overhead which was great benefit for resulting to display at UI Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

Recommendations to others considering PostgreSQL:

It's pretty industry standard and you'll find the community to be very supportive. Also lots of third party support with config management tools like docker/puppet/chef etc. Review collected by and hosted on G2.com.

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

I've used postgres as the primary data source for many production applications. Review collected by and hosted on G2.com.

Carlos Alberto P.
CP
Especialista de Desarrollo
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

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

In our experience we had to make queries that involved the union of multiple tables as well as to use the inheritance one of the characteristics of the database manager to show important information of the company Review collected by and hosted on G2.com.

Maria L.
ML
Specialista IT
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?

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

Recommendations to others considering PostgreSQL:

It's one of the best DB that you can find!

Its:Open source, have a huge and great community, new versions are released every six months (they are very stable too), it support JSON, XML and Geospatial Review collected by and hosted on G2.com.

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

We doing Web-based product and we used it for storage and DB purpose. It is used by our entire organization and is well-integrated iwth our business process. With it we have reduced costs due to licensed sotfware, and speeded up the development in general. We find in PostgreSQL everything we need! Review collected by and hosted on G2.com.

Verified User in Media Production
IM
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

Recommendations to others considering PostgreSQL:

Check your requirements before using Review collected by and hosted on G2.com.

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

I have used it for personal use and in my last organisation for storing user's data and activity Review collected by and hosted on G2.com.

Verified User in Computer & Network Security
AC
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

Recommendations to others considering PostgreSQL:

please use Review collected by and hosted on G2.com.

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

it free opensource we don't want to pay Review collected by and hosted on G2.com.