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.
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.