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.

2 Comments

it_user4401VendorPOPULAR

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.

20 April 13
it_user6579Consultant

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

27 July 13
Guest
Why do you like it?

Sign Up with Email