PostgreSQL is open source, and we can use it in any OS like Windows, Linux, etc. Review collected by and hosted on G2.com.
A stored procedure is not fully supported here, and we can not return a dynamic table. Also, his output window returns only a single query result. Review collected by and hosted on G2.com.
The code/Query you type in the database, if overwritten by another new query by user, the previous query /Queries will still be available in the history, which you can easily refer to and copy the old code Review collected by and hosted on G2.com.
There's not much to Dislike to be honest - but every database may have some or the other query restricted limitations. Such as, in PostgreSQL I could'nt use the LIMIT command and few more - which were working in MySQL server. But other major things were working fine only. Review collected by and hosted on G2.com.
- Simplicity and flexibility compared to other SQL databases.
- Logging is available for each and every activity if you eneabled that so its easy to understand if some users has changed any data.
- We can use complex data types which is available in postgres like geographic objects which help us to manage location data in the database if your application needs to manage user or other location.
- English Documenetation available for easy of use and that will not take much time to learn this database Software. Review collected by and hosted on G2.com.
- The speed of fetching data is very low compare to others.
- Each and every open source software not support PostgreSQL compare to mySQL which support most of each and every open source sotware. Review collected by and hosted on G2.com.
When you think about the performance of a database and it's robustness postgresql is the best option. Review collected by and hosted on G2.com.
Pg admin should be simplified,some times split windows are too crowded to look at. Review collected by and hosted on G2.com.
Postgres is rock solid, widely available, and very performant. In my opinion it is usually best to start with everything in Postgres and spin things out as you scale. Review collected by and hosted on G2.com.
Not much; integrated connection pooling would be nice. And a native column store option. Review collected by and hosted on G2.com.
Postgres has many of the features that I have come to enjoy in more enterprise-scale databases, with the benefit of an open-source pricetag and community support. Review collected by and hosted on G2.com.
If you are looking for a vendor, Postgres isn't your tool. In many ways though, that is a positive. Review collected by and hosted on G2.com.