The best part about PostgreSQL is it is very easy to use in comparison with other SQL Databases.I use Aurora PostgreSQL which is cloud DB provided by AWS. It is very much powerful and the query response time is blazingly fast. Like it can fetch millions of records in seconds only. As a backend nodejs developers I heavily use it by integrating it with the pg node module or dependency. It very easy to setup as it provides pool and client connection object to be attached. Review collected by and hosted on G2.com.

It can be a little complicated for someone who is new to SQL Database or for begginers because of it's deep learning Curve. But there are so many resources and it's official documentation that helps a lot to start. Review collected by and hosted on G2.com.

Postgres is opensource, it supprts scalability, role based access to it also one of the major factor, where people like using it.Even for secure access it provides SSL authentication. Review collected by and hosted on G2.com.

It's bit hard to setup, no user friendly GUI tools like, SQL developer for oracle. I see there is some GUI tool called PgAdmin which I use, which is not that of user friendly like other RDBMS DB's Review collected by and hosted on G2.com.

Postgrest provied very easy to use interface which is very easy to implement as well because of which users preffer to use it frequently and it has n numbers of features which makes it easy to integrate with multiple sowtwares and it has good customer support as well which increase its creadiblity in market. Review collected by and hosted on G2.com.

Postgres is bit slow than MySql and if we delete any records from table then it is not auto vaccume and reindex because of which table size and database size is not reduced which reduces its performace some times. Review collected by and hosted on G2.com.

It's a database that has over 35 years of development. Consistent and stable, reliable yet powerful, it's able to scale and adapt to changing infrastructure as well as be deployed on your choice of platform (any cloud provider, on premise, hybrid or multi cloud). It works great on distributed microservices or as a vertically scaled single instance. Review collected by and hosted on G2.com.

The documentation is very dense and it's not very accessible for beginners who don't have a background in code. More online resources and QuickStarts could be provided to help onboard new developers. Review collected by and hosted on G2.com.

It's very easy to use as compared to other tools in the market and it contains very well prepared documentation on its site. Review collected by and hosted on G2.com.

One thing I dislike about it is it's not easy to use in the starting of usage for a new user. Review collected by and hosted on G2.com.

Its a DB with so many features and cost effective.I have migrated from Oracle to Postgre DB and it helps organisation to save 50% of the original cost Review collected by and hosted on G2.com.

Neecd to imporve support, specially for the PAAS version in Azure Review collected by and hosted on G2.com.

Robust and Stable: PostgreSQL is known for its reliability and stability. It has a proven track record of handling large and complex databases with high transaction volumes.

Advanced Features: PostgreSQL offers a wide range of advanced features, including support for complex queries, advanced indexing techniques, full-text search, geospatial data processing, and more. It provides powerful tools for developers to work with and manipulate data efficiently.

Scalability: PostgreSQL is designed to scale effectively as your database needs grow. It can handle large datasets and high concurrent connections without sacrificing performance.

Open Source: PostgreSQL is an open-source database system, which means it is freely available and can be customized to suit specific requirements. It has a vibrant community of developers who contribute to its ongoing development and provide support.

Extensibility: PostgreSQL supports the creation of custom extensions, allowing developers to add new functionality and extend the capabilities of the database. This flexibility enables users to adapt the system to their specific needs. Review collected by and hosted on G2.com.

Complexity: PostgreSQL can be more complex to set up and configure compared to some other database systems. It requires a certain level of expertise to optimize and tune the database for optimal performance.

Learning Curve: While PostgreSQL offers a comprehensive set of features, it also has a steep learning curve. Developers and administrators need to invest time and effort in understanding the system and mastering its capabilities.

Limited GUI Tools: Compared to some commercial database systems, PostgreSQL has fewer graphical user interface (GUI) tools available. This can make certain tasks, such as database administration and management, more challenging for users who prefer a visual interface.

Memory Consumption: PostgreSQL can consume significant amounts of memory, especially when dealing with large datasets or complex queries. This can be a concern for systems with limited resources or when running multiple instances on a single machine.

Replication and High Availability: Although PostgreSQL provides various replication mechanisms, setting up and managing high availability configurations can be more involved and complex compared to some other databases. Review collected by and hosted on G2.com.

=> SQL database

=> Open-source database it means we can do customization and get community support

=> Easy to manage large volumes of data

=> Allow creating custom data types, operators, events and function

=> Large community so you can solve you problem fast

=> Provide jsonb data type for store json data Review collected by and hosted on G2.com.

=> database is based on project and requirement so if your project is small then I suggest use MongoDB

=> Need the training to understand database functionality

=> Need more storage and computing power to execute query Review collected by and hosted on G2.com.

easy to use we can use it in our production environment, it provide very good features so that we can optimized our query and also data retrieval become easy also in PostgreSQL querys are easy to write, we frequently use it in our projects. Review collected by and hosted on G2.com.

what i don't like is, it is not distributed database, and some features are not supported Review collected by and hosted on G2.com.

Is the best database to store the geom polygons Review collected by and hosted on G2.com.

The sintaxes from some functions are not easy to understand Review collected by and hosted on G2.com.