PostgreSQL Pros and Cons

1- its perfomance is awesome.

2- its response time analysis of query

3- its features like indexing to optimse your query.

4- its easy to use

5- its beginner friendly Review collected by and hosted on G2.com.

1- resource intensive and sometimes it lags

2-once the data is lost then it becomes diffucult and complex to back it

3- when i started working with it i found its setup and configuration is little bit difficult. Review collected by and hosted on G2.com.

Postgre is a database where we have execllent features in wrinting the complex sql queries and easy connection of databases by database integration.The application installation and implementation is easy and the saved data and query does not erase whcih makes way to execute the query often. Review collected by and hosted on G2.com.

The table result set displays only for certain number of rows as it has some limitations.We need to export data everytime to view larger set of results. Review collected by and hosted on G2.com.

PostgreSQL comes with all the existing features of an RDBMS as well as additional extensibility of replicating programming data types likes Arrays, Enumerated & Binary Data etc. Review collected by and hosted on G2.com.

Postgres is not owned by any organization. So, it has had trouble getting its name out there despite being fully featured and comparable to other DBMS systems. Review collected by and hosted on G2.com.

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.