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 9

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

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...
saif eddine m.
SM
saif eddine m.Enterprise (> 1000 emp.)
5.0 out of 5
"My Experience With PostgreSQL"
What i like most about PostgreSQL is the ergonomic interface , easy to understand .

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

637 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.
637 PostgreSQL Reviews
4.4 out of 5
637 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.
Arijit D.
AD
Associate Software Engineer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

A safe, dependable, and robust database is PostgreSQL. It is an open-source RDBMS that performs well while handling a lot of data. Both Linux and Windows operating systems support installing PostgreSQL. SQL expertise is not necessary if we understand the tool adequately. Any database may employ SQL knowledge as well. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For a newbie, PostgreSQL requires instruction. Through PgAdmin, a graphical application is used to manage it. Executing queries on an enormous database might sometimes be a bit sluggish. PostgreSQL installation ought to be simpler for users. Since few individuals utilize this technology, exchanging files or databases with others is challenging. Review collected by and hosted on G2.com.

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

I can utilise PostgreSQL, an open-source RDBMS, for a variety of applications that will reduce the cost to the company. It is quick and straightforward to integrate with other applications and supports a variety of datastore capabilities, including JSON, etc. Review collected by and hosted on G2.com.

JS
Analyst
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Easy to use, simple to maintain for learning purposes. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I used it during a Data Analytics boot camp so I can't speak to how well it works for organizations and teams. No complaints from me. Review collected by and hosted on G2.com.

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

I used it in a Data Analytics Boot Camp to learn SQL queries and creating databases. Review collected by and hosted on G2.com.

Ashutosh O.
AO
Project Manager
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Easy to use, setup and secure database. We are using it for our Secure Java based application since many years. Multi application Integration and deployment is very easy, secure and fast. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it is difficult to extract or modify multilevel json data due to syntax. It takes losts of space when deal with json data. Some open-source application doesn't support postgresql. It is slower as compared to mysql. Review collected by and hosted on G2.com.

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

We are using PostgreSQL for multiple dynamic websites and web apps as java stack option. We are using it for heavy spatial data. Easy to use quick fetching and secure. Great community for quick support. Review collected by and hosted on G2.com.

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

PostgreSQL is a lightweight and open-source RDBMS. It is one of the most widely used Database engines and though it is open source, forward development continues. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Support is one thing that I don't like about PostgreSQL. Review collected by and hosted on G2.com.

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

It is fast. We are using the DB for the analytical purpose also. Review collected by and hosted on G2.com.

ajay k.
AK
Backend Software Developer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL works awesome in production environments. It's secure and scalable relational database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PG store data in storage in it's own cluster which means you also have to keep eyes on directory space. Review collected by and hosted on G2.com.

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

Production scalability and secure easily managed by this database. Admin interface is nice. Review collected by and hosted on G2.com.

Nazim S.
NS
Administration
Information Technology and Services
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

the best thing about the Postgres is the easiest database to learn and handle and the best quality is open source so we can manage or integrate the queries according

our requirement

easy to learn for fresher and the best thing is U can easily access the database using UI Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

sometimes it is difficult to manage unstructured data.

the worst thing is consuming too many threads and processes if 20 queries are fired at a time then it it will consume 20 processes and 20 threads which might slow down the system some time

Postgres is case sensitive which is difficult sometimes to executive a query Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

yes to my colleagues and friends Review collected by and hosted on G2.com.

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

all my data problems are solved by Postgres we have too much-unstructured data which is managed by Postgres.

my app is running using the PostgreSQL database which helps users to host a website and to make a call Review collected by and hosted on G2.com.

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

We have been using postgres as a backend database to store critical metadata and schema efficiently for datalake and machine learning use cases with Cloudera products.

Scalability and ease of configuration and use are some of the features that can be leveraged. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Database restart is required even for user and host level access is modified. A simple reload option or a refresh could have been a better option to deal with such situation. Review collected by and hosted on G2.com.

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

Helping to store critical backend data for datalake and machine learning solutions. Storing all records and schema for tables and their metadata with good performance Review collected by and hosted on G2.com.

Kr. G.
KG
Database Developer (PA-III)
Information Technology and Services
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?

PostgreSQL is a best open source RDBMS for large data.Installation is easy, we can use it on any platfrom either on windows or linux . I have used it on windows OS with pgAdmin GUI tool for its management. Database backup and restoration is very easy through single pgsql command. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL command-line interface is not very much user-friendly so we normally use pgAdmin and its operation is slow with the GUI interface. datatype conversion should also be available with GUI. Scheduling agent is not available in the default installation and PostgreSQL is not convenient for the business intelligence or ETL operation. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Best open source database available. datatype and SQL operations are very much friendly with database developers. Review collected by and hosted on G2.com.

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

We have switched from a widely used database to PostgreSQL and installed it on the Redhat Linux machine. We have used it for data analytics and data transaction purpose, Our international project database with millions of data transactions per day is now on PostgreSQL. Review collected by and hosted on G2.com.

SP
Sr Database Engineer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

PostgreSQL is helpful in getting aggregate functionality using different predefined functions like string_to_agg(), json aggregate Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not a such as of now i found yet. Something can be better for output and message in proper way to handle running queries. Review collected by and hosted on G2.com.

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

PostgreSQL is used to solve a business problem by aggregating into a different way to send output to the requestor Review collected by and hosted on G2.com.

Sumanth S.
SS
Senior Technical Support Specialist
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Installation and setting up.

Running queries,

Ease of use with backup and restoration Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such. It's pretty good for common use cases. Review collected by and hosted on G2.com.

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

Storing of the business records and retrieval using application codes Review collected by and hosted on G2.com.