PostgreSQL Review

PostgreSQL is one of the best Open Source, Object-Relational Data Base Management System available in the market with great features

Valuable Features:

1) Supports large part of SQL standards like Complex queries, stored procedures.2) As source code is free and open, it can be easily distributed, modified and extended according to user requirements.3) PostgreSQL also proves to be a cost-effective solution for organization's as this product is designed and created to have much lower maintenance without compromising on features.4) Excellent GUI tools available for PostgreSQL like pgAdmin III.

Room for Improvement:

1) It tends to be slower when processing a large number of records.2) Does not support the entire ANSI SQL 92' standard.3) More open source applications (software stacks) supports MySQL, but some of them may not support PostgreSQL4) Comparatively small user community than MySQL 5) Installation and setup is bit complex and requires technical know how. Though PostgreSQL is comparatively slower than MySQL, but can handle a heavier workload, and also supports various SQL features like foreign keys, triggers, stored procedures and transaction rollback.

Other Advice:

Great Documentation, active community support, excellent management & development tools and availability on various platforms makes PostgreSQL a good data base management system.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More PostgreSQL reviews from users
...who work at a Comms Service Provider
...who compared it with MySQL
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
510,534 professionals have used our research since 2012.
Add a Comment

author avatarit_user4401 (Developer at a transportation company with 1,001-5,000 employees)

As another pros, I would like to add that PostgreSQL supports subqueries, it is easily configurable, it is good for embedded applications and it works nice with Java and PHP. As a con, I would say that PostgreSQL does not have support built into plpgsql to create web-based procedures.

author avatarit_user6579 (Engineer at a tech services company with 1,001-5,000 employees)

Nice review by Engineer359. Yes PostgreSQL is one of the best Open Source RDBMS available in the market which doesn't need any license cost. Agree with author on pros and cons mentioned by him for the PostgreSQL. Even i would like to add some points based on my experience.
1) Complete support for sub queries
2) Great GUI tool PG Admin
3) Support Views
4) Extensible
5) Great Documentation available on internet