PostgreSQL Reviews & Product Details

Data warehouse functionality and the option of retrieval and indexing Review collected by and hosted on G2.com.

Syntactical and symantic complexity but it can be overcome Review collected by and hosted on G2.com.

I like how simple this software is. It doesn't try to get you with a fancy UI or anything crazy intricate. it's straight forward and it is easy to use for anyone who has SQL experience. Whether in the classroom or at the workplace, it's a really great program for database work. It's user friendly in the sense that is is basic and easy. It may not have all the bells and whistles of other software but that's kind of what I like about it. The output pane when doing queries is nice and simple to read. it's easy to make sure you can see all of the data you need to see in your databases. I also like that the SQL editor gives you color differences on the words so you know that you are entering the correct information. It will come up red if it thinks something is wrong. Review collected by and hosted on G2.com.

It's hard to tell sometimes which DB on your server you are in, as it doesn't highlight it very well. It also is somewhat annoying to have to open a separate screen for actually running SQL. Review collected by and hosted on G2.com.

The best thing about this database is, it is open source. We can customize it according to our requirements. Postgres is portable with all the platforms and programming languages. It does not requires more command line configurations. It is most reliable and stable database. Review collected by and hosted on G2.com.

There are some problems with postgres when we compared it to the mysql database. Low budget hosting sites supports mysql than postgres mostly. In terms of speed, mysql needs less work than the postgres. Also more open sources support mysql but not postgres. These are some of the problems with postgres. Review collected by and hosted on G2.com.

Made for In Memory Computation. Works quite well and inexpensive. Review collected by and hosted on G2.com.

Only good for analytic workloads. Scaling is an issue sometimes, but AWS has made it a breeze Review collected by and hosted on G2.com.

The ease of use, configure and manage. Postgres is a database solution for simple and medium complexity apps. Review collected by and hosted on G2.com.

The app for manage, so I use other generic apps for manage SQL databases, like dBeaver Review collected by and hosted on G2.com.

Best free sql db out there. Reasonably easy to manage, quick. Review collected by and hosted on G2.com.

Don't really have many complaints about the system, security could be better. Review collected by and hosted on G2.com.

Good for simple non critical applicatins, does what says on the tin. replciation backup and recovery is fantastic,. Review collected by and hosted on G2.com.

Documentation and community support should improve, lack of support and help if you are stuck. Review collected by and hosted on G2.com.

Although the speed of response may seem deficient in small databases, that speed is maintained by increasing the size of the database, which is not the case with other programs, which slow down brutally.

Unlimited installation: You can not sue a company for installing it on more computers than the license allows, as there is no cost associated with the software license. This allows for a more profitable business with large scale installations, we should not worry about being audited to see if we comply with the license, and there is flexibility and development without additional licensing costs.

Considerable savings in operating costs: PostgreSQL has been designed to have lower maintenance and adjustment than products of commercial suppliers, retaining all the features, stability and performance.

Stability and Reliability: No database crashes.

Extensible: The source code is available for free, so that whoever needs to extend or customize the program can do so without costs.

Multiplatform: Available on almost any Unix, with 34 platforms in the latest stable version, plus a native version of Windows in test state.

Designed for high-volume environments: Using a row storage strategy called MVCC, it gets better response in large volumes. In addition, MVCC allows read-only accesses to continue reading consistent data while updating records, allowing hot backups

Graphic design and database management tools.

It supports the SQL92 / SQL99 standard and standard type data, clauses, functions, and extended commands of PostgreSQL.

It can operate on different platforms, including Linux, Windows, Unix, Solaris and MacOS X.

Good security system through the management of users, groups of users and passwords.

Great storage capacity.

Good scalability as it is able to adjust to the number of CPUs and the amount of memory available optimally, supporting a greater number of concurrent requests to the database correctly. Review collected by and hosted on G2.com.

Compared to MySQL it is slower in insertions and updates because it has intersection headers that does not have MySQL.

Online support: There are official forums, but there is no obligatory help.

Consume more resources than MySQL.

The syntax of some of your commands or statements is not at all intuitive. Review collected by and hosted on G2.com.

Always number one being Open source. It’s also quite easy to transition from MySQL the learning curve it almost nonexistent. Review collected by and hosted on G2.com.

The Admin tools aren’t that great. Can be a hassle to install on a windows machine. Review collected by and hosted on G2.com.

PostgreSQL gives you the power of traditional relational DBMS system as well as the Power of json present in NoSql databases. You can Keep your table in flexible form to accommodate any kind of data. Review collected by and hosted on G2.com.

It is good only for small and medium scale application, When data volumes exceeds few millions it needs a expert engineer to manage it. Review collected by and hosted on G2.com.