PostgreSQL Reviews & Product Details

The main plus point about PostgreSQL is that it's an open-source R-DBMS that is very reliable, making it a first choice for startups and other organizations. Also, it has gained a high reputation for its high performance while handling high volumes of datasets very efficiently. Review collected by and hosted on G2.com.

One thing I feel that's a downside in PostgreSQL is that its GUI functionality is very limited and not that user-friendly, making it challenging for first-timers to use its complete functionalities, especially when they are not used to the command-line interface. Review collected by and hosted on G2.com.

High compatibility with Oracle SQL and Oracle PL/SQL. With very few changes, you are able to migrate an Oracle Database to PostgreSQL. There are also a good choice for what concern high availability and load balancing solutions. Review collected by and hosted on G2.com.

PostgreSQL is able to manage JSON data with native datatype and APIs. But if you need to query datasets over 10 Gbytes of raw data, consider transforming JSON documents to normalized tables because queries may have time-out issues. Review collected by and hosted on G2.com.

It is open source and freely available, partitioning concept, sql compatibility , support Review collected by and hosted on G2.com.

upgrade process support, complexity on performance tuning Review collected by and hosted on G2.com.

It has a rich and mature feature set where things like referential integrity weren't an afterthought (compared to MySQL). Documentation is also excellent, and modern ANSI SQL syntax is well supported. Review collected by and hosted on G2.com.

It's not as widespread as MySQL is, so it can be harder to find people that are strong DBA skills or know the specifics of its internal workings, but it isn't that bad either. It's not like it's some unknown DBMS either, it's simply not as widespread as MySQL. Review collected by and hosted on G2.com.

PostgreSQL provides an open-source environment to all users. It's easy to use and easy to understand it's functionality. Creating your own data set for testing or exploring new data set both work in the best way. Review collected by and hosted on G2.com.

PostgreSQL is good for beginners but its integration parts didn't work properly. Such as JSON data or others. PostgreSQL needs to work on the integration part of this tool. Review collected by and hosted on G2.com.

Since this is an open-source product, this really helps with day-to-day database development. Review collected by and hosted on G2.com.

I don't really like the user interface, compared to other popular products like SSMS. Sometimes the UI lags. Review collected by and hosted on G2.com.

I like the UI of it. The security part is amazing. I really loved the product, and I am continuously using it in day-to-day work, also Review collected by and hosted on G2.com.

Nothing at all.Everything is just amazing Review collected by and hosted on G2.com.

The upsides of using PostgreSQL include its reliability, scalability, advanced features, open-source nature, and strong community. Review collected by and hosted on G2.com.

Potential difficulties with setup and configuration, complexity that may not be necessary for smaller projects, challenging documentation, and potentially limited third-party integrations. Review collected by and hosted on G2.com.

The language used is universal to most query tools which makes it an easy tool to use and experiment. And learning ina free environment is super helpful Review collected by and hosted on G2.com.

Drag and drop of data values in not available in the latest version, as this feature is available in other editors this was expected and would have been helpful Review collected by and hosted on G2.com.

- The cost(minimal)

- Robust

- Scalability Review collected by and hosted on G2.com.

When I use some specific features, it gets stuck. Review collected by and hosted on G2.com.