PostgreSQL Reviews & Product Details

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.

Probably the best open source SQL solution, universal use due to the possibility of installing extensions. Easy administration and High availability in combination with patroni and etcd. Commercial support by some companies.

Useful extensions:

PostGIS : geography data

TimescaleDB: time series data with automatic partitions, automatic aggregation and deletion

Several options for HA.

Several options for backup and recovery, i personally user Barman (pgbarman.org)

Easy of deployment with containers (Docker, podman, Kubernetes). Review collected by and hosted on G2.com.

Does not support automatic creation of partitions. For automatic partition it is possible to use triggers and PL/pgSQL, extension pg_partman (you have to do manually while locking the database tables) a my preferred way timescaleDB extension and hypertables. Review collected by and hosted on G2.com.

PostgreSQL is a powerful open-source object-relational database management system. It is one of the highly used databases across different organizations worldwide. It can run all operating systems and manage data held in relational databases. It provides support for a variety of data such as images, text, video, audio, and more. It is very easy to learn for new developers as it supports all SQL features and we can add extensions to enable additional functions.

A user can work with PostgreSQL either through the CLI interface or through the pgAdmin desktop application. Once you enter the credentials to connect pgAdmin app with the database all the queries and operations will be in sync with the CLI interface as well. Review collected by and hosted on G2.com.

The only drawback I found using PostgreSQL is that the initial setup is a bit challenging. Sometimes it creates difficulties in creating new users for PostgreSQL and setting up credentials to log in to the database. If this could be made easy it will really help and save us a lot of hours of configuration time. Review collected by and hosted on G2.com.

- It's open-source which means without paying a penny we can leverage a variety of database features with regular improvements and bug fixes provided by community members.

- It's a scalable database that can be used for a variety of applications.

-Its JSONB support makes It easier to work with JSON types and we can work on relational as well as non-relational data on the same system.

- Full text search feature is also provided by PostgreSQL which can help in a variety of applications. Review collected by and hosted on G2.com.

- There are some opensource apps that might not support PostgreSQL but MySQL because It is not owned by a single entity and hence lacks the recognition It deserve.

- Might not be a good solution for the shared dataset as there is no out of the box approach available for it in PostgreSQL.

- It might have a steep learning curve for beginners. Review collected by and hosted on G2.com.