PostgreSQL Reviews & Product Details

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.

PostgreSQL is a great open source Relational database managent tool,it supports Query langueage which is way similar to famous SQL languages that means if anybody have ever worked on SQL then moving onto the PostgreSQL wont take much efforts.it supports all the major data types used in database processing and also gives security related features like role based access and authentication which is the most important feature because it is going to store the confidential information. Review collected by and hosted on G2.com.

i have used postgreSQL locally and over a cloud enviroment, the setup was easy on cloud enviroment but i was continuesly facing a issue for very long time, it was throwing me out of the current session for no reason, i was not able to identify the root cause of this problem but this is something any user wont want to face when he is working on database or storage related tool. locally i have found no issue at all. Review collected by and hosted on G2.com.

PostgreSQL impresses with its robustness, ACID Compliance , and extensibility . Its commitment to standards, comprehensive documentation and strong community support contribute to a reliable and feature rich database management system .

The flexibility to handle diverse data types and advanced indexing capabilities further solidify postgreSQL standing as a top choice for data driven applications Review collected by and hosted on G2.com.

While postgreSQL is feature-rich,its initial setup complexity can be a drawback for newcomers. Additionally, certain performances optimizations may require fine tuning , demanding a deeper nuances, the benifits often outweigh these challenges in the long run Review collected by and hosted on G2.com.

PostgreSQL is recognized as one of the most advanced and robust open-source relational database management systems available.

Strengths:

Open Source: Being under an open-source license allows the community to actively contribute to its development, which accelerates the introduction of new features and fixes.

SQL Compliance: PostgreSQL offers a high degree of compliance with the ANSI SQL standard, which facilitates migration from other database management systems.

Extensibility: PostgreSQL supports the definition of custom types, functions, and operators. This allows developers to expand its capabilities according to specific needs.

Advanced Features: It offers advanced features such as the ability to store JSON data, support for full-text search, partitions, triggers, materialized views, and geospatial extensions (PostGIS).

Security: It offers a variety of security mechanisms, including authentication, role-based access control, and encryption of data at rest and in transit. Review collected by and hosted on G2.com.

Performance Under Extremely High Loads: Compared to some commercial solutions, PostgreSQL may not be as optimized for extreme load scenarios, although for most applications, it is more than adequate.

Management Tools: While PostgreSQL has PgAdmin as its main graphical interface, it may not be as refined or as feature-rich as some commercial tools available for other database management systems.

Replication and High Availability: Although PostgreSQL offers solutions for replication and high availability, the configuration and management of these solutions can be more complex compared to some integrated commercial solutions.

Documentation: Although PostgreSQL's documentation is comprehensive, it can be dense and sometimes difficult for beginners. It could benefit from more practical tutorials or usage examples.

Complexity: Due to its extensibility and wealth of features, PostgreSQL can be perceived as complex for new users or for those coming from simpler solutions. Review collected by and hosted on G2.com.

There are many valuable Postgres extensions. Review collected by and hosted on G2.com.

There is nothing that I dislike about Postgres. Review collected by and hosted on G2.com.

I do really appreciate it's robustness, extensibility and it's strong community support. Review collected by and hosted on G2.com.

Maybe what I dislike on it is the complexity for beginners but once tou got it, it's incredibly powerful. Review collected by and hosted on G2.com.

- It's an open source and free platform for creating and managing relation databases, we used this for all our RDBS needs and since we are a start-up it saved a lot of cost for us in terms of being free and open source.

- It's easy to use and syntactically similar to popular databases like SQL and it helps anyone in the term to learn and quickly adept.

-It's easy to setup even if you are using this on a Google cloud, just do a SSH and you will be able to connect to the postgres instance. Review collected by and hosted on G2.com.

The default user interface is not very feature rich and keeps disconnecting after some session time, there are tools which can be used deparately but if PostgreSQL can improve their user interface it'll be lot better. Even though I am used to command line tool. Review collected by and hosted on G2.com.