PostgreSQL Pros and Cons

Open Source database with a very active and passionate community.

Supports SQL and enterprise applications.

One of the best relational databases around that can be used to support various multimedia.

Very fast and able to provide access based user logins to the database Review collected by and hosted on G2.com.

Initial setup is not straightforward.

Getting through the very customizable options is difficult if you are just starting out. Not an easy task for a beginner to start with.

Limited GUI tools. Puts off many new users who are just starting on this journey as most of the new programmers are more habituated to a visual interface. Review collected by and hosted on G2.com.

PostgreSQL allows us to manage our Dashboards generated using OLAP cubes with amazing speed and reliability. Also, its possibility of using it in Cluster format provides us with a lot of value, guaranteeing accessibility and availability of data, as well as backup copies. The beauty of this software is in the simplicity. Review collected by and hosted on G2.com.

Very few systems can compare with PostgreSQL in my opinion (and integrated with PostGIS, it is great!). But it is true that payment systems such as SQL Server or Oracle have more configuration options, which can be useful for advanced installations. Review collected by and hosted on G2.com.

Its best thing is , it is open source.

Other things i like about postgreSQL is its vast range of Data Types like JSON, Arrays, Custom data types, custom functions and operators. It gives good flexiblity.

It can handle huge amount of data, high traffic loads.

It is suitable for both large and small scale applications.

I love its command line interface.

It is easy to setup.

It can be integrated everywhere.

As it has large and active community it provides regular updates and bug fixes. Review collected by and hosted on G2.com.

As it has wide range of feature it may take some time to learn for beginners.

Its UI tool is not that user-friendly, I rarely use it.

1 Feature they can have is distributed computing. Review collected by and hosted on G2.com.

Postgresql is very easy to use in its pgAdmin and also in other enterprise application like DBeaver. I most like about its connectivety with clouds like AWS's RDS service etc. Best relational and open source database in term of easy to use, database recovery, backup, maintenance and its connectivety. Review collected by and hosted on G2.com.

For beginners its initial setup complexity or the learning curve for advanced features and it's configurations little bit hard because its initial setup is not straightforword specially its port availibilty. Some user may get confused with icons of Postgresql because it may differ from MySQL, Oracle. Review collected by and hosted on G2.com.

PostgreSQL is very easy to use and eady to implementation but i can use cusotmer support of this tools its very frquent to use any person can easy learn and very fast way lots of features available in PostgreSQL like how to import data in very easy way and very easy to integration also customer support might be good not sure about this. Review collected by and hosted on G2.com.

It will take some time to open and import data from CSV file Review collected by and hosted on G2.com.

PostgreSQL offers a powerful GIS extension called "PostGIS" that provides hundreds of functions for processing geometric data. Review collected by and hosted on G2.com.

PostgreSQL may have slower performance than other RDBMS like SQL Server and MySQL. Review collected by and hosted on G2.com.

Best RDBMS tool in the market. Its simple to install, configure and use. It support sql language do DDL DML operations , which supports both OLAP and OLTP workload Review collected by and hosted on G2.com.

Nothing I felt. Everything is simple and easy. Review collected by and hosted on G2.com.

If you are finding databases alternatives to use with your env then postgresql is one of the best choice i can say.

Because it provides a robust and powerful architecture. Anybody want to start to have the knowledge of databases then i can say use the postgresql so that you will have the lots of think clear in your mind and also by passing sometime you definetily love the postgresql database. Quering to postgresql is very much simple and anybody can understand. there are lot to add but you should use postgresql. Review collected by and hosted on G2.com.

Sometimes launching pg admin takes sometime. Review collected by and hosted on G2.com.

I think it is really well documented, you can find lots of free tutorials en webpages and youtube. You can configure it to fit your requirements.

It also has a lot of functionalities, I think it is one of the most advanced databases available right now.

You can integrate PostgreSQL with a lot of different tools, and it provides great advantages for your use. Review collected by and hosted on G2.com.

It can be a little tricky for starters, because the inital configuration can be a little cumbersome, but I think it is not a big deal since you have support online where you can find a lot of tutorials. Review collected by and hosted on G2.com.

postgresql is highly secured.it has SSL certificates for encrypted connections which tells us how secure is it. you can give the accesss basd on role and define the custom rules.i like the perfomance of it in terms of how fast it is it provides you the facilities like indexing, query optimisation etc. so performance wise its beating its competitors in the market. its reliable and stable many companies use this in the production which tells us the trust of companies on its security aspects.its easy to use as a beginner anyone can understand it easily. Review collected by and hosted on G2.com.

its setp and configurations are little bit complex.when you will trigger big queries it occupies larges space so its kind of resource intensive so you may see sometimes performance scaling becomes the major concern. Review collected by and hosted on G2.com.