Open source and great support from the community
Fast and excellent performance for database operations
easy to integrate with other applications(ETL/web apps)
Reliable and easy to maintain. Review collected by and hosted on G2.com.
although pgadmin is great interface for postgres, it freezes at times when running complex queries or queries returning large dataset.
Writing complex queries can be difficult Review collected by and hosted on G2.com.
Not much other than the price. Supported SQ Syntax is similar to Oracle PLSQL Review collected by and hosted on G2.com.
the GUI's /tools are garbage, support is lacking, hard to interface with other appications Review collected by and hosted on G2.com.
- Very easy-to-use graphical interface for carrying out all kinds of tasks.
- Allows table joining.
- Better performance the larger the database. It adjusts to the available hardware.
- Free, open-source. Cross-platform.
- Large community of developers. They provide excellent technical support. Review collected by and hosted on G2.com.
- Not advisable for small databases, although they also have acceptable performance.
- The configuration takes time. Less intuitive than MySQL. Review collected by and hosted on G2.com.
postgres is lightweight and easy to install/reinstall development version in local system,
optimization techniques are different using Query planner/Optimizer and analyze, explain. Review collected by and hosted on G2.com.
Difficult to maintain Transaction control in stored procedures like start/begin and end transaction and commit in between execution. for Large data volume like 20-50~ million, giving performance issue even required a lot of table partition/correctly setting up indexes and was required more query optimization Review collected by and hosted on G2.com.
I love the community around postgres. There are so many great enhancements that they make and the features that you get are fantastic considering the price. Review collected by and hosted on G2.com.
I wish there was more commercial support for community plugins and extensions. Review collected by and hosted on G2.com.
Postgresql is by far the most efficient database manager, this is based on the selection algorithm used in order to determine the fastest route and with the least use of equipment resources, in addition to the effectiveness of the results shown. Review collected by and hosted on G2.com.
There are few things to say negative postgresql however its response time to very simple queries is not as efficient as others in its style, it should be used when the power of its core is required for simple consultations is a waste of resources Review collected by and hosted on G2.com.
- Its free and open Source!
- Transactional support for schema migration,
- Large variety of custom functionality and plugin,
- Great overall performance - perfect for system with low hardware specs - it is light and well optimized
Huge community with a great support Review collected by and hosted on G2.com.
- Backup and Restore of large DB are a bit slow, with some significant performance gap compared with other DB
- Not very User Friendly for new users or for those who are used to using paid software
- The absence of the possibility of the clustering is essential for us, and we must therefore rely on a third part software. Review collected by and hosted on G2.com.
It is pretty easy to use and there are a lot of ORM frameworks on top of it to help Review collected by and hosted on G2.com.
A bit slow sometimes which is an issue. If you have SQL knowledge then sometimes it is bit different from sql so creates confusion Review collected by and hosted on G2.com.