PostgreSQL Reviews & Product Details

Where to begin?

I could start with the fact that PostgreSQL allows you to build sophisticated data models in a mixture of SQL and other languages, seamlessly interwoven. It is one of the most programmable database systems on the market, with SQL being extended in Perl, Python, C, C++, Java, and almost any other language you like.

I could also start with the fact that PostgreSQL has a very advanced and extensible indexing system allowing for B-tree, B+-tree, and inverted indexes over all or a portion of rows, and over the raw data or data calculated based on it.

Or I could start with the fact that it is remarkably scalable, that there are 32-TB databases in existence (though the largest one I have personally worked on was "only" 9TB in size), that people use it to serve millions of requests a day, and that it backs some of the largest players in a number of industries.

The fact is, however, that the database is amazing in part because these major strengths reinforce eachother and that to single one out misses what makes the database so great. Review collected by and hosted on G2.com.

In a few very advanced corners (table inheritance, non-1NF techniques, and the like) there are rough corners. It is rare to hit these though because they are not commonly used functionality.

Also PostgreSQL currently does not have intraquery parallelism though this is coming (with a parallel sequential scan likely in 9.6). Review collected by and hosted on G2.com.

PostgreSQL is rock solid. It's free, it supports multiple platforms and it's widely used.

You can use it virtually from any programming language, and the support will be production level.

I recommend it for learning SQL and for building web applications.

You can start using it with the official docker image in just a few seconds. Review collected by and hosted on G2.com.

It's not easy to find any defects in this software.

I think that the initial server configuration could be easier for beginners, but it is very well documented.

Beware that there is no graphical user interface included with postgresql, but there are a lot of management shells (paid or free). Review collected by and hosted on G2.com.

Really easy sql database to deploy and work with. Currently we are using it as a backend for a Alzheimer database repository. Review collected by and hosted on G2.com.

It was difficult at first o configure and setup at first. A lot of manual configuration and validation was needed to work with our particular project. But after we got it up and running, it did a great job. Review collected by and hosted on G2.com.

Native JSON support (data storage and querying), geo spatial queries through Post GIS and Review collected by and hosted on G2.com.

Somewhat cumbersome initial installation, no multicore querying. Review collected by and hosted on G2.com.

PostgreSQL has some great features. In particular, window functions make challenging (in other flavors of SQL) tasks a breeze. Review collected by and hosted on G2.com.

I have found that the programs available to execute PostgreSQL (that I am aware of) are lacking compared to SQL Server. Review collected by and hosted on G2.com.

Postgres is rock solid and reliable, and has a list of plugins and improvements that really stand out. The fact that a significant portion of the web community has embraced Postgres sets it apart and makes it a clear winner in a lot of situations. It's plugins also allow me to add features easily and quickly without having to add new technology to my stack.

Columns with a specific datatype, hstore for handy, queryable key-value storage, hierarchical features, and full text search are all readily available when you go with Postgres, which is especially handy when starting on a brand new project with rapidly changing requirements. Review collected by and hosted on G2.com.

The thing about postgres that gives me pause is that it's plugin features encourage you to write code that cannot be migrated to other databases. It's a little bit iffy when you're choosing a technology to lock yourself into something thoroughly, and postgres makes it really easy to do that. Review collected by and hosted on G2.com.

It licencing model seems better, and I know I met at least a couple are in Postgress and not MySql ... Review collected by and hosted on G2.com.

Like other free SQL servers it will not understand Oracle keywords , like ROWNUM but it can be emulated. If I am remember correctly LIMIT keyword can be used as approximate translation. Review collected by and hosted on G2.com.

it's open source, free, (relatively) easy to setup. It comes with a bunch of killer features (hstore, json, live queries) It's being updated frequently. There are lots of tools that are built around it. Review collected by and hosted on G2.com.

Scaling and performance tweaking is kind of tricky. No commercial support. Community support is OK (but not as good as MySQL imo) Review collected by and hosted on G2.com.

I use postgres as database in many different projects. Very easy to use. You can quickly learn to use this and create simple to complex queries. Review collected by and hosted on G2.com.

Nothing really to dislike. If required it can be enriched in user experience. Review collected by and hosted on G2.com.

It is a super powerful tool with the ability to get the job done with work with your database. I am newer to SQL and have found this tool to be great with my skill level. I love the ability to export the files I need and the speed in query execution. Review collected by and hosted on G2.com.

Sometimes it can run a little slow and that can be unpredictable without reason. Most times it's very fast, but when it bugs out, you have to restart and it just can be a pain. Review collected by and hosted on G2.com.