PostgreSQL Reviews & Product Details

Coming from a MySQL background, I love the variety of data types in Postgres: JSON, arrays, etc, all fill a need that MySQL didn't. I especially like how easy it is to manipulate dates, something that has sped up development a ton in terms of automated testing. The ability to enforce checks on insertion is very helpful, too. I've used NoSQL before, and I much prefer the rigidity of an RDBMS. All too often I've had to deal with corrupt data because of the temptation to fool around directly in the database rather than using the application layer. Review collected by and hosted on G2.com.

Probably the most difficult thing about Postgres is its permissions model. It's not very intuitive, in my opinion, and I think those issues need to be resolved before it can gain the sort of traction MySQL has. Right now it's just not easy for a beginner to get set up and secure. Review collected by and hosted on G2.com.

love the aggregate functions, also JSONB support, as well as views and materizlized views maintenance. very stable and secure. It is easy for me to maintain as an analyst Review collected by and hosted on G2.com.

certain data types are not good. i find the admin tools to not be amazing either Review collected by and hosted on G2.com.

PostgreSQL seems to scale well compared to MySQL, which means that it's more capable than the latter to withstand a larger database and an increasing number of transactions and connections. Review collected by and hosted on G2.com.

The learning curve seems a bit steep compared to MySQL. And therefore, a beginner might struggle to get started with it. Pgadmin is also not as intuitive as PhpMyAdmin for example and takes a bit of time to get used to. Review collected by and hosted on G2.com.

For the basic level of DB functionality that I need, I honestly see no difference between this or other similar software. Review collected by and hosted on G2.com.

Nothing, it works just fine for my needs. Review collected by and hosted on G2.com.

Postgresql is a very lightweight cross platform solution.

This makes it a perfect alternative to some of the larger commercial solutions out there right now.

The community behind it is also first class, loads of support is available via the forums when needed.

My favorite feature however is replication.

Although you will be editing text based config files to get set up, you can literally have one database replicating to another in half an hour(for basic configs).

I know this is possible with other commercial tools, but Postgres is free to use.

I use it for all of my personal projects when possible.

Review collected by and hosted on G2.com.

Its a little tricky to configure for those who are used to graphical interfaces like in MS SQL server. Review collected by and hosted on G2.com.

open source, large community, some nice functions that get updated. Review collected by and hosted on G2.com.

parallel queries not available yet.

not as frequent w/ patches or new function releases Review collected by and hosted on G2.com.

Solid SQL database, all standard SQL syntax supported with many nice extensions.

Stable

Excellent documentation and good develop support community

Full internationalization support

Good performance

Support for advanced SQL features, like "WITH" clauses and POSIX regular expressions

Built-in full text search (tsearch)

Support for distributed databases - master/slave replication

Lots of native "C" extensions

Right price - open source

Runs on Windows, OSX, and Unix

Installs on OSX using HomeBrew. Review collected by and hosted on G2.com.

PgAdmin tends to crash, losing your query, when you resize the query window. That's been true for over 5 years now. I wish they'd fix that. It might have flaws as larger scales that I use it at, but I haven't seen any yet. Review collected by and hosted on G2.com.

I've worked with many relationnal databases over the years and mysql was my goto solution for web development for a while. Until I was forced to use postgis extension of postgresql for a geospatial data storage project. Since then, postgresql became my defacto databse.

Very reliable, great performance and advanced features make postgresql a solution for midium to large deployment. Advanced data types, especially spatial in my case, rich feature sets and the possibility to write stored procedures in python are a deal sealer.

It's also opensource, with a good support and a welcoming community. Review collected by and hosted on G2.com.

Nothing really, but there is some known gotcha and behaviors that can be confusing for new users. Reading the documentation is a must even if you have a background with other RDBMS.

Tunning the performance of the system is up to the database administrator and the number of options can be overwhelming sometime. Review collected by and hosted on G2.com.

ACID is one of the main features that you will need when programming mission critical applications and postgres has it inbuilt. We can also change the transaction isolation level which is very needed for performance. Consistency is also very good you will never have data corrupution or data lost. JSON support in the latest version has made it very easy for us now since we don't need to migrate the schema always like before. Review collected by and hosted on G2.com.

Scalability and High availability are major issues in sql databases and in postgres its even harder since there no proper tool to do it. It locks the row on serializale transactions which is really a problem in certain cases. Many databases have other means to solve this. Review collected by and hosted on G2.com.

I like PostgreSQL because it's a robust alternative to commercial databases. It stands very well against other open source competitors, like the more popular MySQL. It's fast and reliable, managing inserts and updates of tens of thousands of rows flawlesly.

Besides that, it's easy to install and to manage, and it has some handy non-standard SQL commands. Documentation in the official website covers most of the common and advanced tasks with a lot of examples of querys. Review collected by and hosted on G2.com.

Managing everything from the command line can be a little bit cumbersome. There are a lot of third party graphical interfaces to access the databases from the desktop (pgAdmin) or via browser (phpPgAdmin) but you have to install them and learn to use then on your own.

The same with reporting tools, there are a lot of nice ones but you have to search and try what is the best for you. Review collected by and hosted on G2.com.