The G2 on PostgreSQL

PostgreSQL Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users find PostgreSQL's ease of use exceptional, praising its user-friendly interface and straightforward setup. (14 mentions)

Users appreciate the robustness and feature-rich capabilities of PostgreSQL, highlighting its extensibility and community support. (8 mentions)

Users appreciate the open source nature of PostgreSQL, enhancing accessibility and flexibility for various applications. (7 mentions)

Users value the exceptional customer support of PostgreSQL, benefiting from its robust community and extensive features. (4 mentions)

Users value the easy integrations of PostgreSQL, simplifying their development process with seamless cloud connectivity and user-friendly tools. (4 mentions)

Users find PostgreSQL beginner-unfriendly, as its complex documentation makes initial usage challenging for newcomers. (7 mentions)

Users find the difficult learning curve of PostgreSQL challenging, especially during initial setup and feature understanding. (5 mentions)

Users experience slow performance with PostgreSQL, particularly during large data queries and when importing CSV files. (5 mentions)

Users find feature limitations in PostgreSQL, noting fewer configuration options and GUI tools compared to competitors. (3 mentions)

Users find the initial setup complexity of PostgreSQL challenging, especially for newcomers, despite its powerful features. (2 mentions)

Top Rated PostgreSQL Alternatives

RaimaDB

Visit Website

stephanie c.

Administrador de redes en butterflies design web

Small-Business (50 or fewer emp.)

6/13/2019

"PostgreSQL relational database management system"

4/5

What do you like best about PostgreSQL?

PostgreSQL is undoubtedly one of the most well-known and used database servers.

OPEN SOURCE

One of the main reasons for using PostgreSQL is that it is developed under open source (Open Source), we can find it available on its official website and download it without any cost. also has a MULTIPLATAFORMA

If we require a database to work on our project, the most common is that we ask what database to use that gives us performance, security and in turn we can use it both in the office and outside of it, and one of the Most common cases is that we do not all have the same operating system. And here is another reason to use PostgreSQL: we will not have to worry about this detail anymore, because it is available in virtually all versions of Unix operating systems and also for Windows, giving us the opportunity to have it installed locally, make a remote connection to through your PgAdmin administrator or also from the application you are developing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

This compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL.

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

It consumes more resources than MySQL.

The sintaxtis of some of its commands or statements is not intuitive at all.

These are some of the annoying things about PostgreSQL. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

that this is a database server that by all the features already presented is good to use it for all the benefits that it has when creating a database Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

is a free relational object database server, since it includes features

of object orientation, such as inheritance, data types, functions, restrictions,

triggers, rules and transactional integrity, released under the BSD license. Like many others

open source projects, the development of PostgreSQL is not managed by a single company but rather

is run by a community of developers and commercial organizations. Review collected by and hosted on G2.com.

Verified User in Automotive

Mid-Market (51-1000 emp.)

11/21/2019

"Highly recommend - easy to use and does connect to so many applications "

4.5/5

What do you like best about PostgreSQL?

Easy of use - tons of community guidelines and stack overflow users have solved most of the problems Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

We went for the paid version but is pricey but thats just one part - the postgres DB actually wants you to learn their own syntax which takes time of you are new Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Highly recommend but you need to learn the language Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We replaced it from IBM db2 and it seems like It connects with many applications easily. We are using it to integrate with in house python applications and works perfect. However we haven’t actually signed off with this application officially but it is under due consideration Review collected by and hosted on G2.com.

Lopata C.

Project Engineer

Small-Business (50 or fewer emp.)

6/7/2019

"Create your secure and robust database"

4/5

What do you like best about PostgreSQL?

is a computer tool that you can obtain free downloading from your website, easy to install both in private operating systems and open source and this allows you to create a database with different parameters and tables that will make your database fast and secure too has the advantage of working with different types of files for the storage of information so that when consulting tables is faster has an option called triggers that allows to automate statements in the database to perform execute command so automatic. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is usually difficult to install linux operating system since it must be installed manually using the command console and indicate in which sites the installer file is located, it also tends to be flawed when it has multiple databases or when a database It is very small since it is indicated and developed for a large data base. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

is a very useful tool and its advantage is that totally free that will work to manage database of great information for systems in both web development environment and desktop environment as they are developed in java is light when installing and you do not need more resources for its execution, however, the system usually becomes a bit heavy depending on the number of information it manages and the way in which it is managed correctly. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I worked to use this database with the system and extensive information that our client needs and are developed in turn is implemented and integrated with several tools for developing programs such as netbeans and eclipse. Review collected by and hosted on G2.com.

David C J.

Computer Engineering

Small-Business (50 or fewer emp.)

6/5/2019

Business partner of the seller or seller's competitor, not included in G2 scores.

"manage your database securely"

4.5/5

What do you like best about PostgreSQL?

It is a super fast tool and the best of all for free to manage database of large volume or size; it is compactible for both windows and other operating systems. Its configuration is easy and its functionality is surprising since it allows you to manage a database of data that contains multiple tables in a fast and secure way to access the information asks you to log in and has an endless file format to save the information. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

in database that are not large, or it is usually slow search or may even fail, you need some plugins or components to integrate with other software which makes it a bit difficult to configure. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I recommend this database administrator for its quick way of installation and configuration in turn for the way to administer the tables and database because it allows to interlace tables and have a better response quickly and without any error. It works both for proprietary operating systems or open source, and you do not need to have a large computer to use this tool because it does not consume much requirements. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We have served to make and safeguard our information in a safe manner and with multiple forms of protection. This tool also allows us to encrypt our information in case any person wishes to access it, it can not be achieved. its installation is totally free and compactible for java and php application development. Review collected by and hosted on G2.com.

Nigel H.

Technical Architect/Manager

Small-Business (50 or fewer emp.)

8/16/2019

"Fast and Underrated, great database"

4.5/5

What do you like best about PostgreSQL?

It does stored procedures, indexes, benchmarks are excellent, its FREE. Does multiple languages in Unicode, stores objects. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The only free tool is pgadmin and its good but you have to pay to get a good database admin tool. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Its fast and very well done. We have 1500 clients with thousands of patients and it works fine. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

sometimes you have to write a query in a special way so that Postgresql is efficient at processing the sql correctly. Review collected by and hosted on G2.com.

Michell R.

Gerente de Proyectos

Small-Business (50 or fewer emp.)

8/3/2018

"Database manager very powerful and the best thing is that it is free!"

3/5

What do you like best about PostgreSQL?

This management system offers performance characteristics that have evolved over time. Also its use and constant review of the developer community have made it one of the most stable systems in terms of open source refers to. The graphical environment offered by Pgadmin allows an intuitive and easy to manage administration. If you have used other database administration systems, the adaptation to Postgre SQL will be very fast and little traumatic. The SQL statement editor is very practical, which allows to perform the operations most commonly used in any database. Finally, the backups and recovery of databases are carried out quickly and in a few steps. The reliability of this function is very high. Particularly, during the time I have been using this manager I have not presented any type of error or catastrophic loss Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The main hosting providers do not support database of this management system. The big corporations still have resistance for the use of this manager. The support is provided by the developer community, which produces long periods of time to resolve. It does not have an error identification and traceability mechanism. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Free technologies are not necessarily unstable. If you require a database management system with good security features, information integrity for a medium volume of transactions, try PostgreSQL Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

In countries where the use of free technologies is encouraged, great benefits can be obtained because there are no additional payments for user licenses and the client owns the generated code, which allows its administration and modification without inconvenience. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

10/22/2019

"PosgreSQL"

5/5

What do you like best about PostgreSQL?

Licensing model is very flexible. Database can be embedded as part of an application or installed separately. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

GUI UI isn't the best. PGAdmin is a local application that is installed as a web based application. It can be flakey to get running. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Understand use of database to allow power to assist your implementation Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Storage of both discrete and nondiscrete data in a single database. The flexibility allows for implementation of many use cases including dynamic types. Review collected by and hosted on G2.com.

Román Josué d.

Data Scientist

Small-Business (50 or fewer emp.)

5/18/2019

"PostgreSQL: a great choice for open source Relational DBMS"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is one of the best options to work with relational databases. Having worked a lot with databases and having the experience to work with PostgreSQL made me realize how this is one of the most solid options for working on this area. It's the best open source for SQL and possibly the best among all, either open source or no.

PostgreSQL provides you with high performance and solid robustness. It's easy to import, export, and deploy databases. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The PGAdmin could be improved. While it's a functional inteface, it could be improved and made faster and easier to use. Review collected by and hosted on G2.com.

Mayra B.

Developer

Enterprise (> 1000 emp.)

10/15/2019

"PostgreSQL"

4.5/5

What do you like best about PostgreSQL?

It is totally free, it is open source, it integrates with many database managers, it has many functionalities, inheritance of tables, several views, transactional integrity Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

rigorous security and authentication mechanisms must be applied to avoid any vulnerability in the system Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Take courses, read, there is a lot of information on the web very useful, to be good professionals and in the case of companies have highly trained staff Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Database management, integration with information systems, handling high transaction volumes Review collected by and hosted on G2.com.

Abdul Basit Z.

Geographic Information System Officer

Information Technology and Services

Small-Business (50 or fewer emp.)

8/15/2019

"PostgresSQL is the most effective"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is fast and available with very small latencies on most clouds. I believe it's a SQL taste, particularly compatible with my coding style and a straightforward natural query interface. It operates robustly and can be easily distributed without crashing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres is perfect to say it has no flaws and we can't ask for Oracle's scope or features because, as a consequence, this instrument is safe. However, for example, the other tools aren't the only ones I saw and don't like. Review collected by and hosted on G2.com.