PostgreSQL Reviews & Product Details

PostgreSQL is free and open source and fits great in any project size.

It's easy to connect to PostgreSQL with any technology.

It has a strong and active community. Review collected by and hosted on G2.com.

Lacks popularity.

Performance in read-heavy operations. Review collected by and hosted on G2.com.

- the price

- the availability of great support, for example at the mailing list and at Stackoverflow

- the features to keep the data valid (checks, triggers) Review collected by and hosted on G2.com.

I somewhat dislike the necessity to setup and use pgbouncer or similar, I would have better preferred everything to be available in a single package.

Also, optimizing performance for my needs has been a tedious process. Review collected by and hosted on G2.com.

Everything. It supports all the SQL-92 standards, plus some of their own editions. It has a very mature GIS querying and every type of index. It supports in memory and a ton of different trigger languages. There's no feature or item missing from postgresql.

Use it and you will be happy.

It's an exact replacement for oracle without the cost. Supports triggers, procs, functions and everything you can think of including a datascience machine learning package MADLIB.

There's no reasons not to use Postgresql. The drivers for Java and Scala and NodeJS are excellent. Postgresql also powers a lot of servers like Cloudfoundry. Review collected by and hosted on G2.com.

The problem with Postgresql is that there's a lot of version and no single owner of the enterprise verison. No really a concern. Review collected by and hosted on G2.com.

Geospatial data is very handled by the PostGIS extensions. Review collected by and hosted on G2.com.

The command line interface is quite foreign from the conventions of other systems, and lacks many useful features like tab completion for identifiers. Review collected by and hosted on G2.com.

This is RDBMS that i use the most. I like the performance and and also hstore. Review collected by and hosted on G2.com.

Its relational database, its not specific to postgres. But when im working in research project i will not use RDBMS because in research schema change often. Review collected by and hosted on G2.com.

PostgreSQL was my first database that I used when initially developing rails apps and I prefer to use it if I have the option. It's open source, and it's well maintained. There is also a huge community of people who use it so there are plenty of answers for questions on stackoverflow etc. Review collected by and hosted on G2.com.

Off the top of my head there isn't anything I dislike about it. Once you learn to use it it is pretty straightforward and there is a lot of documentation for learning to use it. I would certainly recommend it over other options like mysql in terms of ease of use, although it depends on what you want to use it for. Review collected by and hosted on G2.com.

PostgreSQL is stable and performs well, even at large connection loads. They have the best documentation of any piece of software I've dealt with. On top of that, it's completely free! Review collected by and hosted on G2.com.

The default GUI for interacting with the database isn't very intuitive. Scaling can be a problem due to the rudimentary clustering tools and lack of third party support. Review collected by and hosted on G2.com.

This database can do just about anything. For a modern web application the support for JSON, and JSONB columns is incredible. The addition of native upsert in 9.5 is huge, too. Review collected by and hosted on G2.com.

Managing PostgreSQL is generally not quite as much "fun," or as simple as SQL Server, or MariaDB. Review collected by and hosted on G2.com.

PostgreSQL is an open source relational object-orieneted data management system. It has been improved, and provide a variety of features that I need at my work. Review collected by and hosted on G2.com.

The system scalability, and capability for big data Review collected by and hosted on G2.com.

During my 3-4 years of being exposed to PostgreSQL in a professional environment, everything being transactional was quite good, partial indexes are awesome and helped me optimize things quite a bit for the application at Vonage that was running on EnterpriseDB at the time (2006-2007). At the time, the feature set was a bit better than MySQL, which was my primary expertise. We were trying to substitute Oracle with PostgreSQL for a specific task we had. There was also a rather large at the time deployment of snort logging into postgres (500 gigs or so before it started falling over)

I liked the way backups and restores were described for getting a snapshot in time, as in "backup the data even if it's changin, then backup the log files, with some function calls here and there" Review collected by and hosted on G2.com.

Replication, at least in 2006-2007 was slony and log-shipping. Slony would fail to create new replicas after about 100 gigs on somewhat serious enterprise hardware due to it recreating the database via a pg_dump method which obviously stops working after certain level of data size is reached. Was a pretty bad time, 1/5 stars, would not repeat.

Some of the commands were just dowright tedious.

processlist ? some obscure table, or function call.

kill a process ? yet another obscure function call

see all the tables and sequences ? \d, naturally

just the table ? \dt, everybody knows that

show create table, doesn't exist - have to break into pg_dump

show create function/trigger/view/event/etc - nope, pg_dump for you

Not sure if this is the same way still, but replication is the major win for MySQL currently, it's easy to have replicas, all the information and monitoring is easy to retrieve. Review collected by and hosted on G2.com.