A safe, dependable, and robust database is PostgreSQL. It is an open-source RDBMS that performs well while handling a lot of data. Both Linux and Windows operating systems support installing PostgreSQL. SQL expertise is not necessary if we understand the tool adequately. Any database may employ SQL knowledge as well. Review collected by and hosted on G2.com.
For a newbie, PostgreSQL requires instruction. Through PgAdmin, a graphical application is used to manage it. Executing queries on an enormous database might sometimes be a bit sluggish. PostgreSQL installation ought to be simpler for users. Since few individuals utilize this technology, exchanging files or databases with others is challenging. Review collected by and hosted on G2.com.
Easy to use, simple to maintain for learning purposes. Review collected by and hosted on G2.com.
I used it during a Data Analytics boot camp so I can't speak to how well it works for organizations and teams. No complaints from me. Review collected by and hosted on G2.com.
Easy to use, setup and secure database. We are using it for our Secure Java based application since many years. Multi application Integration and deployment is very easy, secure and fast. Review collected by and hosted on G2.com.
Sometimes it is difficult to extract or modify multilevel json data due to syntax. It takes losts of space when deal with json data. Some open-source application doesn't support postgresql. It is slower as compared to mysql. Review collected by and hosted on G2.com.
PostgreSQL is a lightweight and open-source RDBMS. It is one of the most widely used Database engines and though it is open source, forward development continues. Review collected by and hosted on G2.com.
Support is one thing that I don't like about PostgreSQL. Review collected by and hosted on G2.com.
PostgreSQL works awesome in production environments. It's secure and scalable relational database. Review collected by and hosted on G2.com.
PG store data in storage in it's own cluster which means you also have to keep eyes on directory space. Review collected by and hosted on G2.com.
the best thing about the Postgres is the easiest database to learn and handle and the best quality is open source so we can manage or integrate the queries according
our requirement
easy to learn for fresher and the best thing is U can easily access the database using UI Review collected by and hosted on G2.com.
sometimes it is difficult to manage unstructured data.
the worst thing is consuming too many threads and processes if 20 queries are fired at a time then it it will consume 20 processes and 20 threads which might slow down the system some time
Postgres is case sensitive which is difficult sometimes to executive a query Review collected by and hosted on G2.com.
We have been using postgres as a backend database to store critical metadata and schema efficiently for datalake and machine learning use cases with Cloudera products.
Scalability and ease of configuration and use are some of the features that can be leveraged. Review collected by and hosted on G2.com.
Database restart is required even for user and host level access is modified. A simple reload option or a refresh could have been a better option to deal with such situation. Review collected by and hosted on G2.com.
PostgreSQL is a best open source RDBMS for large data.Installation is easy, we can use it on any platfrom either on windows or linux . I have used it on windows OS with pgAdmin GUI tool for its management. Database backup and restoration is very easy through single pgsql command. Review collected by and hosted on G2.com.
PostgreSQL command-line interface is not very much user-friendly so we normally use pgAdmin and its operation is slow with the GUI interface. datatype conversion should also be available with GUI. Scheduling agent is not available in the default installation and PostgreSQL is not convenient for the business intelligence or ETL operation. Review collected by and hosted on G2.com.
PostgreSQL is helpful in getting aggregate functionality using different predefined functions like string_to_agg(), json aggregate Review collected by and hosted on G2.com.
Not a such as of now i found yet. Something can be better for output and message in proper way to handle running queries. Review collected by and hosted on G2.com.
Installation and setting up.
Running queries,
Ease of use with backup and restoration Review collected by and hosted on G2.com.
Nothing as such. It's pretty good for common use cases. Review collected by and hosted on G2.com.