PostgreSQL Reviews & Product Details

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.

PostgreSQL is open source database management solution. For SQL queries, it supports both SQL and JSON. Also we can use complex data types and performance optimisation tools that we would normally only find in pricey commercial databases. And as per the develoeprs view we can create custom data types , functions and all and if configured correctly , we can perform complex data operation , recursive queries and many more. Review collected by and hosted on G2.com.

If we talk. About the speed then mysql is works beeter in that but PostgreSQL works more on compatibility. And also just one thing that many open source application support needs to be given in PostgreSQL.to add this just one thing if it is not configured correctly , it can give issues while optimisation. Review collected by and hosted on G2.com.

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.