Very fast for running queries from bash or within PGAdmin ; ability to lauch queries from PHP Review collected by and hosted on G2.com.
Using variables in not as simple as in MySQL. I prefer PgAdmin 3 rather than PgAdmin 4. Review collected by and hosted on G2.com.
Functionality and organization of data is clean and concise Review collected by and hosted on G2.com.
installing the application/software can be challenging for newer/less-experienced users. Review collected by and hosted on G2.com.
This database allow us to interface the databases in a nice GUI that will interact with the database inside. Review collected by and hosted on G2.com.
The GUI was a little slow and took a long time to run script to generate data. Review collected by and hosted on G2.com.
I've been using PostgreSQL for many years, and although there are alternatives, I've found that for most use cases PostgreSQL is the RDBMS to go for.
It's not only because of its simplicity or its features. The main reason is that it is tuned to most workloads and you don't have to fine-tune or play with configuration files a lot: it simply works.
This really feels like the developers put a lot of care when designing the RDBMS engine and when choosing defaults. I still have to find a workload PostgreSQL is not suited for. Review collected by and hosted on G2.com.
This is not a complain, as I'm okay with the command line and fine using and configuring it through SSH in my servers, but a lot of colleagues find it difficult to do this. Most of them, accustomed to point-and-click solutions, or more mainstream databases, find it difficult to make the switch. Review collected by and hosted on G2.com.
Performance almost at par if not better than some of the commercial products out in the market. Supports a broad array of data types out of box. Open Source. Strong developer community. Review collected by and hosted on G2.com.
Might suffer in speed especially if the queries are not well written. (Unforgiving in general, which might be a good thing). Generic Error Messages Review collected by and hosted on G2.com.
user interface and commands are easy and comprehensive. It is well integrated into every application for web, mobile etc... Most useful database system for lots of data Review collected by and hosted on G2.com.
Not much. Some times I forget about the commands in terminal Review collected by and hosted on G2.com.
Cross platform
Designed for high volume of data.
Never crashes and is at no charge.which is the best thing. Review collected by and hosted on G2.com.
Not great to interact with web applications. Review collected by and hosted on G2.com.