PostgreSQL Reviews & Product Details

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.

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.