It works robustly, Well supported by backend frameworks. Stability and ability to handle structured data are pretty good. Review collected by and hosted on G2.com.
Configuration can be a little overwhelming for those who are new, but users can refer - https://www.postgresql.org/docs/ for better understanding. Review collected by and hosted on G2.com.
Opensource DB, Highly Secure, Stability, Scalability, Highly performance-oriented. Review collected by and hosted on G2.com.
Data compression, Columns reordering, its default availability on all hosts. Review collected by and hosted on G2.com.
1) It is a free and open-source database system.
2) It is secure and robust compared to other relational database systems.
3) Easy to store large amount of structured data in the database system.
4) Querying time is super fast and quick.
5) Frequent updates from time to time. Review collected by and hosted on G2.com.
1) It is a bit confusing compared to other database systems.
2) Sometimes slow with big queries.
3) Apart from these cons, it's a great relational database system. Review collected by and hosted on G2.com.
The best thing is its is open source, it supports the B+ tree, GIN (Generalized Inverted Index) and GiST (Generalized Search Tree).The project is supported by a number of corporations and people. Review collected by and hosted on G2.com.
Changes for performance enhancement need more work than in MySQL since PostgreSQL primarily has software compatibility goals. Many open source applications support MySQL, but not PostgreSQL. Review collected by and hosted on G2.com.
Easy Installation and Configuration, supports multi-platforms like Windows, macOS, Linux, use existing applications.
Highly reliable open source RDBMS.
Lots of features compared to its competitors. Review collected by and hosted on G2.com.
Lacks schema versioning, Parallel data query, Feels lacking in performance compared to competitors especially in writing to the database. Postgre upgrade from 9 to 10 was not that great, there was a lot of downtime. Lacks in-memory modes.
Less documentation which may be impediment to new users. Review collected by and hosted on G2.com.
- Querying time is considerably faster
- Free and open-source database
- Easy to install and configure Review collected by and hosted on G2.com.
- Consumes somewhat higher CPU usage so that efficiency is a bit low Review collected by and hosted on G2.com.
only postgresql provides enterprise-class performance and functions among current open source dbms with no end of development possibilities. also, postgresql users can directly participate in the community and post and share inconveniences and bugs. Review collected by and hosted on G2.com.
The UI is not that user friendly. I could improve much better way. Review collected by and hosted on G2.com.
Highly compliant with SQL standards, able to handle large complex queries. Supported by the majority of platforms such as Amazon Redshift and DynamoDB. Great for application data processing. Review collected by and hosted on G2.com.
Slow process speed, not a good fit for real-time data processing Review collected by and hosted on G2.com.
Is a good database for non-critical applications that required less level of effort for administration and support. Review collected by and hosted on G2.com.
At the moment i do not find any dislike whatsoever Review collected by and hosted on G2.com.