PostgreSQL is one of the best choice when it comes to managing relational databases and it is available to use for free! It provides an ease of use to its users. It allows developers the freedom of using many languages eg. Python for scripting. It works well with large amount of data too. Review collected by and hosted on G2.com.
Processing big data is need of the day and very much required in all businesses. Even though postgreSQL can support large databases, It is not suitable for big data due to large computation time. Review collected by and hosted on G2.com.
I like the way it manages the database and connectivity, and the version is free and unlimited. It is stable and reliable, very secure.
Very secure when storing information and stable on different operating systems. Review collected by and hosted on G2.com.
it does not have online or phone support but rather a forum where your questions will be answered.
it tends to be slow in insertion and updating in low-volume databases, it is oriented towards databases with large storage capacity. Review collected by and hosted on G2.com.
PostgreSQL allows us to easily run queries and cross-reference information from various tables of data we have stored. As a subscription-based service with millions of user emails and information, this is extremely important. Review collected by and hosted on G2.com.
While simple for someone who knows SQL there is a learning curve. It would be amazing if PostgreSQL allowed for easy implementation of a UI that was friendly to those who are not familiar with the coding behind queries to run searches in order to pull information from various sources. Review collected by and hosted on G2.com.
Postgres is an incredibly stable database workhorse. It handles production traffic with ease, and its default settings are generally very stable and scalable. It links easily to all sorts of ETL tools and supports all major ORM libraries. Review collected by and hosted on G2.com.
Well, just like any SQL database, by default it's not vertically scalable. So once you can't upgrade your database server hardware further, you sort of hit a cap, until you put in sharding logic. Review collected by and hosted on G2.com.
I pretty much enjoy the elastic factor in its design and implementation. Offers a huge deal with data storage and security. As compared to MySQL and other database systems, PostGresSQL stands out as the go-to database when it comes to data redundancy and better maintenance.
The pricing is not bad either and cloud solutions providers offer great supports. I should know, I use them whenever I need. Review collected by and hosted on G2.com.
The setup is not that easy mostly on the Linux environment. The user has to have a better knowledge about the installation and usage before engaging on this database choice but it is worthy to spend time and energy learning. Review collected by and hosted on G2.com.
The PostgreSQL server has the advantage of having the security features of a paid service database, and the features of an open source database such as contact support, strong customer base which makes the service unique. Review collected by and hosted on G2.com.
There are few technical glitches while trying to login using PostgreSQL server, because of this issue I had to uninstall the application multiple times to login into the server. It also has a problem regarding the duplication and restoring the database. Review collected by and hosted on G2.com.
Postgres is very stable. Borrows some features from both relational database systems and NoSQL databases giving it very complex and powerful hybrid features. Review collected by and hosted on G2.com.
Although postgres has been growing recently, it is not easy to find a professional who is well trained in postgres compared to other more popular DBMS like MySQL, Microsoft SQL and Oracle Review collected by and hosted on G2.com.
The simple GUI, combined with the CLI commands - makes this database very easy to use. Additionally, the fact that it is open-source and powerful makes it a go-to database for everyone. Review collected by and hosted on G2.com.
No dislikes as of now. PostgreSQL being such a good open-source database, one would have to nit-pick really hard to find out something. Review collected by and hosted on G2.com.
Good open source database that implements the SQL standard. Very easy to administer, and standard SQL works well with it. Review collected by and hosted on G2.com.
Their internal database commands in psql are a little confusing at times. Commands like \d \d+ etc. QL Review collected by and hosted on G2.com.
Open source.
Huge plug-ins offerings.
Great documentation. Review collected by and hosted on G2.com.
Less known than MySql for example.
Less used by enterprise companies,
No official support representative for solving problems. Review collected by and hosted on G2.com.