Lots of ANSI SQL features, array support, extended type support, great query planner works well with custom types. Free without strings. Runs on windows, mac, and Linux. Review collected by and hosted on G2.com.
Needs parallelization for queries like SQL Server and Oracle have. Need ability to replicate single databases easily. Review collected by and hosted on G2.com.
There are window functions. It makes a lot of things to be solved much easier than without them. Hive databases also have similar functions so it's relatively easy to move to Hive from PostgreSQL. Also has a function already available to create a custom functions. Review collected by and hosted on G2.com.
Not the best performance on reading operations compared to MySQL database. Review collected by and hosted on G2.com.
It is very fast for large amount of data. The front end client (pgAdmin III) is bundles with the database and is very responsive for a large number of concurrent connections. Review collected by and hosted on G2.com.
A steep learning curve for proprietary configuration. Review collected by and hosted on G2.com.
One of PostgreSQL's best features is strong adherence to the ANSI-SQL:2008 standard, which makes it a very comfortable choice when switching from other database systems. It's open source, well maintained, industry proven and battle-hardened, with a rich set of features that I could not begin to list here. I've consistently been impressed by its extensibility, stability, and robust set of built-in functions, including handy cryptographic functions. I make regular use of nested transactions, wide language support for stored procedures, and complex subquery expressions. This is a powerful tool suitable for a wide variety of application domains, and it is well supported in every major programming language with drivers and connectors. A plethora of tools exist to interact with your PostgreSQL databases, from command line to powerful GUI tools suitable for both experienced and novice users. Review collected by and hosted on G2.com.
Configuring PostgreSQL instances can be challenging, and is not to be entertained by the layman. If you can, find an experienced DBA to handle configuration of your instances or cluster, unless you have a very competent system/database administrator in-house. It will work just fine out-of-the-box, but more demanding integrations require configuration tweaking. Review collected by and hosted on G2.com.
Extremely easy to setup. Good security features. Can easily deploy in the cloud or use pre built Amazon services. Review collected by and hosted on G2.com.
The GUI. pgAdmin has not been a very stable product. But once you work through the issues it does the job. Review collected by and hosted on G2.com.
The documentation is very well written and logically laid out. I can't find anything in the MySQL docs but familiarity is certainly a factor.
Rock-solid stability and point-in-time recovery. Go ahead -- pull the plug!
When working with spatial data the PostGIS extension is very powerful. Review collected by and hosted on G2.com.
Nothing! Review collected by and hosted on G2.com.
Either free or way more affordable than other Database software, i.e Oracle. And they are not owned by Oracle, as opposed to MySQL which is not Larry Ellison's property. More robust and secure compared to MySQL. Review collected by and hosted on G2.com.
Not as fast as MySQL, although not signifigantly slower Review collected by and hosted on G2.com.