PostgreSQL Pros and Cons

What do you like best about PostgreSQL?

The speed in conjunction with the native JSON support. With the on the horizon 9.5 the added features will only deepen my appreciation for Pg. Being able to have all the functionality of a NoSQL type DB on top of a a traditional RDMS makes using something like Couch/Mongo obsolete. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I am not the biggest fan of the vacuuming that is required for larger datasets. Eventually most people hit the dreaded "transaction wraparound" error if they are not careful and it is a nightmare to recover from sometimes. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Flexibility, fullness of features and easy extensibility.

for almost anything you might want there's usually an extension that provides this - if not, it's very easy to write your own.

other than that you have the basics fully covered, Loads of SQL features, fast performance, HA,...

Also, the lack of centralized data dictionary is greatly simplifying design for multi-tenancy applications as it allows for a straightforward approach.

Last but not least, postgresql as a product advances in an impressive rate, catering for more and more use cases and deployment options, with great emphasis on performance and data consistency.

It's exciting to see the product and community evolve - make a quick comparison between 9.2 & 9.5 and you'd be amazed what a couple of years can do. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's still behind some of the big players in terms of the optimizer - it lacks many smart optimizations which means that for really complex stuff, you are still better off with Oracle or SQL Server.

(then again remind yourself of the bill :) ) Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Postgresql is an sql engine that supports a huge load of transactions and has a great community support, the documentation is wide and implementation is not as hard as some people claim, plus it's supported on most today cloud service providers. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If one comes from mysql or sqlite, postgres can be a bit difficult, specially with the database and table specification, but this depends on the SO too so this can be a problem for some and not a problem for others. A lot of the old classic shared hosting providers still don't support postgres. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

PostgreSQL is very robust, easy to use and has a nice documentation. It comes with a lot of built-in tools such as generating unique identifiers (UUID/GUID) and has many ready to use plugins such as PostGIS for geospatial querying. If your organization uses a relational database, then PostgreSQL is as good as it gets. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As with any SQL database, PostgreSQL has a lot of limitations. The biggest limitation that in my application is full-text search. To be fair, PostgreSQL does come with some nice tools for full-text search, but relational databases are not designed for this stuff and you're better off using a specialized tool like ElasticSearch, which happens to work pretty well with PostgreSQL. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Fast fetching large data. Able to store and somewhat able to search json blobs. Able to use inheritance in tables. Based on well known sql language. Lots of info in admin tables Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The size grows like crazy. After a db export/import it can shrink to 30% the size with the exact same DB which means lots of space was wasted. Tons of tables can be slow to vacuum and that can cause a DB crash. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Postgres has been an incredible open source tool for our company as we've grown. We switched from MySQL, which we quickly outgrew, and have been going strong on a Python+PostgreSQL build ever since. It's easy to get new DB users up and running on simple tasks, and has great flexibility with its user defined functions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

All the graphical query tools that are also free are mediocre at best. There are some really good ones, but they require a subscription. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

I like that is very powerful and also free. It has a lot of interfaces for almost every programming language and lets you storage big objects, like pictures, videos and sound files. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't like the tool pgAdmin, that lets you manage your databases graphically. It doesn't work well, is really slow, doesn't have prediction when you are writing queries and also stops working without any reason.

Another thing that I don't like is that you have to use LIMIT x instead of TOP x to get some x quantity of rows Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Fast, extremely scalable, in active development, easy to learn and use, complies with SQL standards, and can handle large GIS data sets with PostGIS. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Upgrading minor versions is sometimes a pain with the PostGIS extension. We occasionally have to dump and reload the entire database to get things working without losing data. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

After years using other SQL database, I decided to give PostgreSQL a go.

It is amazing how easy it is to integrate to any solution. I've used PostgreSQL in many environments and I was always glad for choosing this database engine. In every language that I use to develop with Postgres there are built-in tools to make my life easier.

PostgreSQL also supports a huge amount of data types, including user defined types which makes the life of a developer way easier. I also feel that I need way less plugins or tools to develop with. It works perfectly out of the box and has a great performance.

Seeing great tools like Heroku adopting Postgres is amazing and just confirms that this is indeed a great tool.

Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Coming from MySQL I miss the Admin tools. PostgreSQL has loads of tools that you can use to manage your database but none will top MySQL Workbench or even phpMyAdmin. Even trying clone tools like phpPgAdmin, it is just not the same. Working on big project without a great database design tool makes it a bit harder to adapt.

Postgres has great tools, but it still behind comparing to other solutions. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

The features in PostgreSQL are excellent, other competing products are years behind in the tools that are already available. It is very configurable for almost any kind of environment and product you are building, if you need high availability, redundancy, clustering, etc. it is supported. Lots of granularity in the data being stored. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Coming from a product like MySQL that is much simpler than PostgreSQL can seem a little overwhelming as you get up to speed on documentation and configuration guides. Review collected by and hosted on G2.com.