PostgreSQL

4,6 (412)
Escreva uma avaliação!
Sistema de gestão de banco de dados relacional de código aberto

Classificação geral

4,6 /5
(412)
Relação qualidade/preço
4,7/5
Recursos
4,6/5
Praticidade
4,3/5
Suporte ao cliente
4,1/5

98%
dos usuários recomendam este app
Classificar por

412 avaliações

Jorge
Jorge
Classificação geral
  • Setor: Software
  • Porte da empresa: 2–10 funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 10.0 /10

PostgreSQL - A World Class DBMS that you can have for free

Avaliado em 11/03/2021

I have used PostgreSQL for Windows since 2008 and it has been a pleasure. Some DBs have tables with...

I have used PostgreSQL for Windows since 2008 and it has been a pleasure. Some DBs have tables with more than 1 million records and performance seems not to be affected.

Vantagens

It is free although there are some paid options that include support and special configurations. It is very stable, I have not had any critical situations like data loss. As a ASP.NET developer, it integrates easy using ADO.NET Data Providers for which there are many choices. Concurrency control is included which is very useful for data integrity. Versions for Linux, Mac, Solaris and BSD are available which increases the integration power. A huge number of third party add-ons (paid and free) can be found. PostgreSQL is being continuously improving, there is a well defined plan of maintenance and new versions are coming out regularly.

Desvantagens

I have not found anything against this DMBS product. I have accomplished all of my goals successfully.

Alternativas consideradas

MySQL

Razões para mudar para o PostgreSQL

A professional friend of mine recommended it. Additionally and after doing some research, I found PostgreSQL origins date back to 1970´s as a successor of Ingres developed at University of California Berkley. This definitely called my attention and I decided to try as a first option. I felt in love with PostgreSQL.
Janne
Janne
Classificação geral
  • Setor: Telecomunicações
  • Porte da empresa: 10.000+ funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 9.0 /10

One of the best overall databases in the market

Avaliado em 29/06/2021

For overall backend database purposes I would currently not choose anything other than PostgreSQL....

For overall backend database purposes I would currently not choose anything other than PostgreSQL. Widely known, easy to hire talent for, secure and reliable.

Vantagens

PostgreSQL is well supported by backend frameworks like Django. Getting into the command line of PostgreSQL database isn't necessary that often, but when a must, it works very robustly.

Desvantagens

Not suitable for some data types as well as some of the competition, like time series data, that is becoming more and more important via IoT use cases.

Alternativas consideradas

MySQL

Razões para escolher o PostgreSQL

Generational leap in web development, a new product was launched.

Software anterior

MySQL

Razões para mudar para o PostgreSQL

Best direct support from backend frameworks such as Django.
Pedro
Pedro
Classificação geral
  • Setor: Software
  • Porte da empresa: 2–10 funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 6.0 /10

database alternative to mysql

Avaliado em 26/09/2019

it's a really good database manager, easy to use and the community version is free to use in a...

it's a really good database manager, easy to use and the community version is free to use in a commercial environment

Vantagens

in general is a good database manager like MySQL you have many functions and one, in particular, the notifications, you can send a notify and it's like a broadcast message, useful for interaction with the backend

Desvantagens

the way how to backup and restore is sometimes complicated, we tried to automatized and sometimes works others not, the same script! and because of that, you can have an empty DB

Javier
Javier
Classificação geral
  • Setor: Serviços e tecnologia da informação
  • Porte da empresa: 11–50 funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Probabilidade de recomendação 10.0 /10

One of the BEST Open Source Relational Data Base System

Avaliado em 19/11/2021

In general, my experience with Postgre has been very pleasant.
The systems that I have developed...

In general, my experience with Postgre has been very pleasant.
The systems that I have developed using this software as a data manager have been stable.
When I have had technical problems it has been possible for me to find the solutions within its great community

Vantagens

its compatibility with previous versions makes development very friendly.
It is also Open source and free, which allows saving costs in the development of systems.
there is a lot of documentation online to find solutions to problems In addition to having a large community

Desvantagens

It's official handler is not friendly.
Installation for begginners is not easy.
configure advanced functions such as replication It is complicated

Alternativas consideradas

MySQL

Razões para mudar para o PostgreSQL

Due to what is a software with great performance even though it is free
daniel
Classificação geral
  • Setor: Segurança de rede e informática
  • Porte da empresa: 51–200 funcionários
  • Usado Semanal durante 6 a 12 meses
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 10.0 /10

"PostgreSQL: Ease and Efficiency in Application Development

Avaliado em 23/10/2023

From the first time I tried this software, I knew it stood out. All my databases now reside in it,...

From the first time I tried this software, I knew it stood out. All my databases now reside in it, not just for its efficiency, but for the sense of security and trust it gives me. Even when running it on less powerful machines, and experiencing some slowdowns, it has always delivered on its promises. I've been with it for nearly 7 months and have no regrets; it's been a solid choice for my projects

Vantagens

I started using it because of my university and I was instantly charmed by how user-friendly the software is with its tools. I have two databases and it has never let me down. Its security is good and the information doesn't get lost.

Desvantagens

Throughout my journey with PostgreSQL, I've had moments of love and frustration. While I adore its sturdiness and the features it offers, I've stumbled a couple of times with its performance in specific scenarios. Sometimes, it feels like that reliable old car you know inside out, but occasionally takes a bit longer to start. Despite the minor hiccups, it remains my go-to companion when I want my data to be safe and well looked after

Manasseh
Classificação geral
  • Setor: Fabricação elétrica/eletrônica
  • Porte da empresa: 2–10 funcionários
  • Usado Semanal durante Mais de um ano
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 10.0 /10

PostgreSQL is an Open Source tool of the highest caliber for Database Management.

Avaliado em 15/09/2023

Nowadays, I nearly always utilise PostgreSQL for my projects. It is incredibly durable when...

Nowadays, I nearly always utilise PostgreSQL for my projects. It is incredibly durable when utilised in my engineering sector both at business and with home projects, yet versatile enough to support my speedy deployment of web apps.

Vantagens

I love using PostgreSQL for the following main reasons, firstly databases with a lot of data can be stored, it is possible to have different settings for various databases on a same server and on top that it costs nothing to use PostgreSQL since it is an open source software.

Desvantagens

One of the drawback of the PostgreSQL is CPU usage is rather high.

Rahul
Classificação geral
  • Setor: Hospitais e Saúde
  • Porte da empresa: 1.001–5.000 funcionários
  • Usado Semanal durante Mais de um ano
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Probabilidade de recomendação 8.0 /10

Quality review of PostgreSQL

Avaliado em 29/09/2023

Vantagens

- Good management of data tables & possibility to have service of multiple Servers

Desvantagens

- Great to improve user interface & SQL query error classification to make easy accessibilities of data.

Nuno
Classificação geral
  • Setor: Software
  • Porte da empresa: 51–200 funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 9.0 /10

A good DB for any kind of company

Avaliado em 19/08/2023

Vantagens

It's a very powerful DB for the price, it has all the features and customization that any db admin needs.

Desvantagens

Without a db admin, the features may be restricted to the basic ones, unless someone researches how to do things

Thushan
Classificação geral
  • Setor: Software
  • Porte da empresa: 201–500 funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 8.0 /10

Postgress as a relational DBMS.

Avaliado em 26/05/2023

Vantagens

I have used this several times while I was studying and in my company also. t supports ACID properties and it can handle high traffic. I can use database indexing, different data types. functions, aggregates and complex queries. There's a huge community support and I asked for assistance twice from them.

Desvantagens

I doubt the performance of this when I handle complex queries.

Avaliador Verificado
Classificação geral
  • Setor: Terceirização/Deslocalização
  • Porte da empresa: 1.001–5.000 funcionários
  • Usado Mensal durante Mais de um ano
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 10.0 /10

An industry standard rdbms

Avaliado em 23/11/2023

Vantagens

It’s an industry standard tool - we use it for all kinds of CRUDS

Only gave 3 stars on ease of use because I am not the most educated user!

Desvantagens

No cons - mostly PEBKAC issues at most, but it’s not PostgreSQL’s fault!

Avaliador Verificado
Classificação geral
  • Setor: Logística e cadeia de fornecimento
  • Porte da empresa: 201–500 funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Probabilidade de recomendação 10.0 /10

Best open-source RDBMS out there

Avaliado em 06/06/2022

Overall, we have a very productive experience with PostgreSQL. Whenever we need a backend database...

Overall, we have a very productive experience with PostgreSQL. Whenever we need a backend database for any of the apps we deploy, we use PostgreSQL. It never fails us.

Vantagens

I like how easy it is to set up and deploy a PostgreSQL database. It has a rich ecosystem of tools and a great open-source community behind it.

Desvantagens

I don't have anything I dislike about PostgreSQL.

Alternativas consideradas

MySQL

Razões para escolher o PostgreSQL

For some tools we deployed, we naturally needed to scale up and handle more complex workloads. So we changed our backend database.

Razões para mudar para o PostgreSQL

Out of many open-source tools we deploy, PostgreSQL is the most widely supported DB backend among others. So we decided to use PostgreSQL whenever applicable.
Abbas Yusufzai
Classificação geral
  • Setor: Petróleo e energia
  • Porte da empresa: 51–200 funcionários
  • Usado Semanal durante Mais de um ano
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 9.0 /10

Postgre SQL.. Best 2D spatial database tool for geologists.

Avaliado em 05/06/2021

It's a pretty reliable database manager that provides for excellent data management and a very...

It's a pretty reliable database manager that provides for excellent data management and a very comprehensive security implementation, as well as the installation of procedures that make data integrity easy to maintain.

Vantagens

One of the advantages of this manager is that it is simple to install and has a free license for various distributions and operating systems. It also allows you to configure the manager according to the team requirements. Other capabilities include the ability to run read-only queries while in recovery mode. pg-Admin, for example, is a graphical application that allows us to simply administer our database. It is a great resource distribution for complex queries, very adjustable, allowing it to be tailored to the needs of individuals who use it, Allows you to limit the number of incoming connections to avoid timeouts caused by developers.

Desvantagens

Indexing is some times very slow. Also database syncing or importing and exporting database is some time a headache. Apart from that, I don't see any major shortcoming in it.

Samuel
Classificação geral
  • Setor: Telecomunicações
  • Porte da empresa: 2–10 funcionários
  • Usado Diariamente durante Mais de um ano
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 8.0 /10

Best Relational Database and it's Open Source

Avaliado em 17/05/2023

I've found PostgreSQL to be a powerfully efficient and secure tool for managing relational databases

I've found PostgreSQL to be a powerfully efficient and secure tool for managing relational databases

Vantagens

PostgreSQL excels in its strong documentation, large data handling, and exceptional security.

Desvantagens

Challenges with screen navigation, JSON handling, and data comparison can make it less user-friendly

Avaliador Verificado
Classificação geral
  • Setor: Software
  • Porte da empresa: 201–500 funcionários
  • Usado Diariamente durante 1 a 5 meses
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 8.0 /10

My choice for IoT

Avaliado em 02/04/2023

PostgreSQL is a powerful database that can handle complex IoT applications. Additionally, the...

PostgreSQL is a powerful database that can handle complex IoT applications. Additionally, the security features of PostgreSQL make it an attractive option for companies dealing with sensitive data.

Vantagens

Security is very important in IoT. PostgreSQL offers robust security features such as SSL encryption and row-level access controls, ensuring that data is kept safe and secure. PostgreSQL is highly scalable and can handle large volumes of data, making it ideal for IoT applications that generate huge amounts of data.

Desvantagens

PostgreSQL has a steep learning curve compared to other databases. Its advanced features and complex commands can be overwhelming for new users. While there is a large community of PostgreSQL users, finding professional support can be challenging, especially for companies with specific needs.

Belmin
Belmin
Classificação geral
  • Setor: Serviços e tecnologia da informação
  • Porte da empresa: 2–10 funcionários
  • Usado Mensal durante 1 a 5 meses
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 8.0 /10

Best free SQL solution

Avaliado em 05/06/2023

Overall the best free SQL solution for enterprise.

Overall the best free SQL solution for enterprise.

Vantagens

Free and solid, good user support, good for enterprise, frequent updates.

Desvantagens

Might be difficult at start but it’s still the best free SQL solution.

Rishikumar
Classificação geral
  • Setor: Software
  • Porte da empresa: Profissional autônomo
  • Usado Diariamente durante Mais de um ano
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 10.0 /10

"PostgreSQL: A Robust and Reliable Database Solution"

Avaliado em 19/01/2023

Overall, my experience with PostgreSQL has been positive. It is a robust and reliable database...

Overall, my experience with PostgreSQL has been positive. It is a robust and reliable database system with advanced features for data management and analysis. The active community and comprehensive documentation make it easy to get started and the software is well-suited for a wide range of applications.

Vantagens

PostgreSQL is a powerful and flexible open-source relational database management system. It offers high performance, rich SQL support, and advanced data types, such as arrays, hstore, and JSON. It can be used for a wide range of use cases, from small web applications to large enterprise systems. The active community provides a wealth of resources, tutorials, and support, which helps to easily create custom functions and operators. It also allows scalability, which makes it suitable for handling an increasing amount of data and users. Additionally, it supports ACID properties, which ensures data consistency and integrity in the database. Overall, PostgreSQL is an excellent choice for businesses looking for a powerful and flexible relational database management system, it offers great features that make it a great tool for most of use cases.

Desvantagens

PostgreSQL is a powerful and versatile open-source database system that offers many advanced features for data management and analysis. Its robust SQL engine and built-in support for advanced data types make it a great choice for a wide range of applications. While the software can be a bit complex to set up and manage for beginners, the comprehensive documentation and active community make it easy to get started. Overall, I highly recommend PostgreSQL for anyone looking for a reliable and feature-rich database solution.

Ralica
Classificação geral
  • Setor: Software
  • Porte da empresa: 11–50 funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 10.0 /10

PostrgreSQL has been in my toolbar for over 10 years now!

Avaliado em 23/02/2023

Vantagens

ACID compliantRobust and secureAllows different transaction types to co-existAsynchronous and synchronous replicationScalable

Desvantagens

Use this for your mid to large-tier projects.

Avaliador Verificado
Classificação geral
  • Setor: Automação industrial
  • Porte da empresa: 501–1.000 funcionários
  • Usado Semanal durante 6 a 12 meses
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 8.0 /10

Best second choice

Avaliado em 15/02/2023

Vantagens

Transactional features haves distinguished PostgreSQL from MySQL in the past and was our choice every ti e we need it. It is still very strong, with support for clustering.

Desvantagens

unfortunately it has been surpassed by MariaDB in all areas in my opinion, and it rests only as a second choice if, by any reason, you can’t use MariaDB.

Alternativas consideradas

MongoDB e MySQL
Federico
Classificação geral
  • Setor: Software
  • Porte da empresa: 11–50 funcionários
  • Usado Semanal durante Mais de um ano
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 10.0 /10

A great open source alternative.

Avaliado em 15/02/2023

Vantagens

The community is one of the main aspects that make postgreSQL so attractive, with its open source DBMS and the ability to participate.

Desvantagens

While it's a great alternative and easy to use, it may not offer the fastest speed. If you need efficiency you may need to look somewhere else.

Aníbal
Aníbal
Classificação geral
  • Usado Semanal durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 10.0 /10

PostgreSQL is powerful and robust, it fits perfectly in large projects

Avaliado em 07/07/2018

With PostgreSQL I have been able to perform my work satisfactorily on multiple occasions, my bosses...

With PostgreSQL I have been able to perform my work satisfactorily on multiple occasions, my bosses and I are happy with the results we have obtained, saving hardware investment costs because we have focused on the database, I hope to have future benefits to the use it in projects for own clients.

Vantagens

I really like PostgreSQL I have used it several times for large projects in my previous works and in the current one it is used as a database for the web page of the institution, the power of PL / pgSQL is excellent, it allows me to program commercial layers in the database without any problem this improves the response times of the final applications and allows investments in hardware in the database servers instead of in the application, the management of schemes is perfect. It is important to mention that it is free software that implies having a large database without licensing costs. A feature of PostgreSQL is the multiversion concurrency control that allows transactions consistent with time, which provides great performance advantages. PgAdmin is a graphical tool with which I can manage different databases easily and intuitively, execute SQL statements, as well as create backup copies or perform maintenance tasks. Another thing that I like about PostgreSQL is that it is available for many platforms, it is possible to install it from the repositories of the Linux version that I use. It should be noted that the PostgreSQL user community is one of the most active in the market

Desvantagens

There are some things that I do not like about PostgreSQL, permissions allowance per user can be annoying, I have had to work many times on this and it is difficult, it is also relatively slow when I insert and update small databases. The official support does not have telephone or online support, although there are official forums available where users can express their doubts to which other users of the community respond. The syntax of some of your commands or statements may not be intuitive if you do not have a medium level of knowledge in the SQL language. I have had problems migrating from a PostgreSQL version to a higher one. Compatibility is sometimes relative.

Avaliador Verificado
Classificação geral
  • Setor: Serviços ao consumidor
  • Porte da empresa: 501–1.000 funcionários
  • Usado Semanal durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 9.0 /10

Reliable Open-Source Database

Avaliado em 20/01/2023

Overall I think, additionally to MySQL, PostgreSQL is my favourite relational database because of...

Overall I think, additionally to MySQL, PostgreSQL is my favourite relational database because of the already mentioned benefits.

Vantagens

The biggest benefits PostgreSQL databases offer are in my opinion that they are super reliable, performant, open-source and are working with common SQL standards.

Desvantagens

If you are really honest, compared to some other alternatives, PostgreSQL databases have a low reading speed.

Usman
Classificação geral
  • Setor: Varejistas
  • Porte da empresa: 11–50 funcionários
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Relação qualidade/preço
  • Praticidade
  • Suporte ao cliente
  • Probabilidade de recomendação 8.0 /10

A very reliable, steady and no cost RDBMS

Avaliado em 23/09/2022

Overall experience on PostgreSQL has been good. A very low maintenance is require which is...

Overall experience on PostgreSQL has been good. A very low maintenance is require which is definitely a plus point. Also, see many medium to big size organization using this RDBMS for their mission critical application.

Vantagens

Steady and reliable.
Open source and doesn't require licensing
Very less performance tuning is required

Desvantagens

Don't find native ETL Tool
Yet to see functionality of data marts and data warehousing

Avaliador Verificado
Classificação geral
  • Setor: Publicidade e marketing
  • Porte da empresa: Profissional autônomo
  • Usado Diariamente durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 5.0 /10

Solid database, but not user (or even admin) friendly

Avaliado em 25/09/2021

Vantagens

It's a solid database tested over the years by half of the world. Whatever features you need it has it.

Desvantagens

You'll often need to Google for the exact command you need to run, the docs are very dry and the syntax is unconventional.

You'll suffer greatly trying to write code to access the database.

If you want to upgrade, scale, or do anything significant with a large production database you're probably best off hiring a specialized consultant - it's risky and not easy.

Alternativas consideradas

MySQL

Software anterior

MySQL
Avaliador Verificado
Classificação geral
  • Setor: Serviços e tecnologia da informação
  • Porte da empresa: 501–1.000 funcionários
  • Usado Diariamente durante 6 a 12 meses
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 9.0 /10

Open source database with advance features

Avaliado em 31/07/2021

We have deployed 100 of PostgreSQL instances as the back-end for state owned LMS. Databases are...

We have deployed 100 of PostgreSQL instances as the back-end for state owned LMS. Databases are well performing and never receive any complaints regarding performance after the GO-LIVE. We have deploy PostgreSQL for simple web application to the enterprise grade internet banking app.

Vantagens

+ Install is very easy
+ Support almost all platform
+ Data aggregation is fast
+ Good documentation from vendor and community
+ Highly stable
+ Secured

Desvantagens

+ Working with JSON etc. is not easy comparable to other products
+ Poor data compression mechanisms
+ Bit resource hungry

Alternativas consideradas

MySQL

Razões para mudar para o PostgreSQL

The main reason is performance.
Rafał
Rafał
Classificação geral
  • Setor: Consultoria de gestão
  • Porte da empresa: Profissional autônomo
  • Usado Semanal durante Mais de dois anos
  • Fonte da avaliação

Classificação geral

  • Praticidade
  • Probabilidade de recomendação 9.0 /10

Postgresql (psql) is a great way to start with "serious" RDBMS

Avaliado em 17/05/2022

Postrgresql was a DB engine for our retail stores cashier system. TCO was 20% compared to Oracle...

Postrgresql was a DB engine for our retail stores cashier system. TCO was 20% compared to Oracle (including hardware and support). Fast, flexible and with great support of programming languages, with API compatibility helped us to run a full scale retail chain (16 offline stores) with real time stock management in our online store.

Vantagens

+ scalability
+ SQL compilant
+ security
+ open source (free but not without costs)
+ offers more field types than mysql
+ API compatibility
+ low TCO - cheaper than Oracle (but with similar performance)
+ great programming language support (Python, PHP, C++ etc)

Desvantagens

- free (open source) does not mean witout costs. Sometimes it is very hard to find a specialist that can properly handle PG issues
- not present at most of hosting services (but you can always run a virtual machine on AWS EC2)
- less tools for data manipulation/analysis compared to MySQL