Über PostgreSQL

Kostenloses Open-Source, Post-abhängiges Datenbanksystem. Führende Wahl von Entwicklern und DBAs weltweit. Robust, sicher, leistungsstark

Erfahre mehr über PostgreSQL

Vorteile:

The price vs others other there ie, MSSQL is a lot better. It is able to capture and process data very quickly.

Nachteile:

If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize.

Bewertungen zu PostgreSQL

Durchschnittliche Bewertung

Benutzerfreundlichkeit
4,3
Kundenservice
4,1
Funktionen
4,6
Preis-Leistungs-Verhältnis
4,7

Weiterempfehlungsquote

9,0/10

PostgreSQL hat eine Gesamtbewertung von 4,6 von 5 Sternen basierend auf 331 Nutzerbewertungen auf Capterra.

Hast du PostgreSQL bereits verwendet?

Teile deine Erfahrungen mit anderen Softwareinteressenten.

Nutzerbewertungen filtern (331)

Rafał M.
Rafał M.
Owner in Polen
Verifizierter Nutzer auf LinkedIn
Unternehmensberatung, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

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

5 letzten Monat Neu

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

Vorteile:

+ 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)

Nachteile:

- 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

Verifizierter Rezensent
Data Analytics Manager in Philippinen
Verifizierter Nutzer auf LinkedIn
Logistik & Lieferkette, 201-500 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Best open-source RDBMS out there

5 vor 3 Wochen Neu

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

Vorteile:

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.

Nachteile:

I don't have anything I dislike about PostgreSQL.

Albernes G.
progamador in Venezuela
Verifizierter Nutzer auf LinkedIn
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

easy to use and understand

3 vor 4 Jahren

Kommentare: It can operate on platform specifications, including Linux, Windows, Unix.
Large storage capacity
Good scalability since it is able to adjust to the number of CPU and the amount of available memory optimally, supporting a greater number of simultaneous requests to the database correctly.
It supports the types of data, clauses, functions and commands of standard type SQL92 / SQL99 and extended own of PostgreSQL ..

Vorteile:

its graphic environment and considerable savings in operating costs: PostgreSQL has been designed to have a maintenance and adjustment lower than the products of commercial suppliers, while retaining all the characteristics, stability and performance. Stability and reliability: There have been no drops in the database

Nachteile:

That Compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL Support online: There are official forums, but there is no mandatory help It consumes more resources than MySQL .

Vin C.
Development Manager in Australien
Informationstechnologie & -dienste, 2-10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Fully tried and tested.

5 vor 3 Monaten

Kommentare: Really well supported by the open source community.

Vorteile:

Easy to setup development wise (Postgres.app), Very well supported by primsa DB. (orm client).

Nachteile:

Cloud pricing tend to be more expensive vs mysql option.

Jonathan alexander C.
Jonathan alexander C.
IT infrastructure analyst in Dominikanische Republik
Verifizierter Nutzer auf LinkedIn
Krankenhausversorgung & Gesundheitswesen, 1.001-5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

A robust database engine for your web projects and platforms

4 letzten Monat Neu

Kommentare: I have used this database to carry out web projects in the health sector and it has been of great help to manage processes and data in a very efficient way and with the best performance that I have seen.

Vorteile:

What I like most about this database engine is its security, scalability and high performance for the development of platforms and web applications, easy to maintain and manage

Nachteile:

That I did not like the product, its difficult or complex syntax, sometimes the very tedious query error

Shaune G.
Data and Research Associate in USA
Non-Profit-Organisation Management, 11-50 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Postgres for a small database

5 vor 2 Wochen Neu

Kommentare: Great product; easy to use with AWS RDS; lots of functionality

Vorteile:

I was new to database management. Postgres is widely used and there are vast resources that help bring me up to date or help me solve problems.

Nachteile:

All database software is hard to use. I also had a problem with PGAdmin after an update and had to switch to a different DBMS.

Dikshyaraj B.
Dikshyaraj B.
Infosystem Engineer in Indien
Verifizierter Nutzer auf LinkedIn
Einzelhandel, 1.001-5.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

The best RDBMS of 21st century

5 vor 4 Wochen Neu

Kommentare: postgresql is something i use 80% of the day.
The features i have used on same are helped me a lot in terms to develop existing db activities.
The parallel query execution and operations facility is the best thing i love in postgre.

Vorteile:

The functionality and availability of postgresql db can be highly appreciated. The parallel schema instaces allows user to run paralled different operations on same dbs. The file/data type supported are almost all types. The ability to join more tables than any other rdbms is something postgresql stands out in market.

Nachteile:

I did nt find any cons in postgre as compared to other rdbms,i find it the best in market. If i need to tell a con then i want it to become as fast as SAP-HANA-DB.

Malik W.
Malik W.
Data Analyst in USA
Verifizierter Nutzer auf LinkedIn
Forschung, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

PostgreSQL

5 letzten Monat Neu

Vorteile:

It is a good Software for those who need SQL.

Nachteile:

It can sometimes take a while to compile and have errors like all programming softwares.

Anil C.
Marketing Executive in Türkei
Marketing & Werbung, 5.001-10.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Database PostgreSQL Platform

4 vor 2 Wochen Neu

Kommentare: My team is using PostgreSQL to cover all the database platform to enhance different kind of perspective of developer team.

Vorteile:

PostgreSQL is easy to database platform to use every section of marketing and developer team, it is easy to navigate between section.

Nachteile:

PostgreSQL has different kind of database platform, it is easy to navigate between them but sometimes it is little bit freezing when you want to load the data.

Siddharth S.
Siddharth S.
Business Analyst in Indien
Verifizierter Nutzer auf LinkedIn
Computer-Software, 201-500 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

The best data warehouse for a saas product

5 vor 2 Monaten Neu

Vorteile:

Easy to integrate with every tool that can be used for product analytics. Provides several types of schemas and user controls that can be used to share data with different types of users.

Nachteile:

Yet to face a single problem with postgres.

Janne M.
Janne M.
Technical Product Manager in Finnland
Verifizierter Nutzer auf LinkedIn
Telekommunikation, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

One of the best overall databases in the market

5 vor 12 Monaten

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

Vorteile:

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.

Nachteile:

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.

Jorge M.
Jorge M.
Software Engineer in USA
Verifizierter Nutzer auf LinkedIn
Computer-Software, 2-10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

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

5 letztes Jahr

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

Vorteile:

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.

Nachteile:

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

Adolfo M.
Adolfo M.
System Administrator in El Salvador
Verifizierter Nutzer auf LinkedIn
Staatsverwaltung, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Very complete and stable database

4 vor 2 Jahren

Kommentare: I have very good experience installing and configuring databases with PostgreSQL.
Once installed and configured it is very stable, almost without errors and one can rest assured that the data is fine

Vorteile:

It is very complete for any type of project or application. It is stable, easy to use and can handle a lot of structured data. It is free software and is very well documented It is very popular and has a very varied community around the project

Nachteile:

Its installation and configuration can be a bit complex at first. Being free they are not obliged to provide support Requires specific tuning for each possible scenario

Verifizierter Rezensent
Senior Software Engineer in USA
Verifizierter Nutzer auf LinkedIn
Computer-Software, 201-500 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

The right database for 95% of use cases

5 vor 2 Jahren

Kommentare: Postgres is there for you whenever you need to store and retrieve simple tabular data. Whether that's your app user's name, email, and settings, or the projects and project content that they've created. As long as you're not dealing with over 10k transactions per second, it's cheap to use and extremely easy to set up. Oh, and it's also not great but just okay for advanced searching such as full-text search.

Vorteile:

- Postgres is just soooo reliable, it's hard to corrupt or lose data unless you go in and manually edit or delete the data. - Battle-tested ACID transactions to make sure you only update the data when it makes sense to have saved me so much time. - The SQL interface is easy to use once you've mastered SQL (which it isn't; it's the simplest of all the languages I've learned). - Newer versions even has support for advanced use cases such as arrays and JSON objects. - The best thing is that 90% of the backend software developers know Postgres (or MySQL which is pretty dang similar) so help is never too far away!

Nachteile:

The only real reason to not use Postgres is that it is pretty hard to scale. If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize. Postgres provides poor support for identifying the queries that are running really slowly. e.g. you have to install a buggy plugin and then query a funky poorly documented table. Trying to do master-slave replication is also quite difficult as you often run into consistency issues and will have to modify app logic. In these cases, it's better to go with NoSQL obviously.

Tigran H.
Tigran H.
Developer in Armenien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 11-50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

PSQL databse.

5 vor 2 Jahren

Kommentare: Overall this is good software to use when you in a large applications.

Vorteile:

This is one of the best database software I’ve used. It has a lot of features/functions that are usable for Big projects. One of them I've use is the PSQL vector search that is not widely used but very important feature that built in PSQL, beside that it has a tons of usable functions to do operations inside database and then get the result for example timezone adjusting, manipulation with data, string function and etc.

Nachteile:

Trully telling there should be few cons in this software. I've used this for over 4 years sometimes find to difficult to configure it it linux environments compared with mysql.

Nairoby D.
Nairoby D.
Consultor in Venezuela
Verifizierter Nutzer auf LinkedIn
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

It's free!

5 vor 4 Jahren

Kommentare: In my very particular opinion I feel comfortable working with Postgres for more than 10 years, it is reliable and safe, the best thing is that it is free, which allows you to save on licenses, it is ideal for any type of development. I totally recommend it

Vorteile:

- Free code database manager, which is not used for licensing. - Easy to install and configure in any operating system. - Ideal for relational databases. - It has a large community in which you can share doubts. - It is stable and reliable, scalable and secure with the correct user management. - Can work with small and large databases. - Handles the SQL language. - Being free software, it is compatible with several graphic tools that help administration and database design. I particularly recommend working with PgAdmin in its latest version for postgres 9.6.6 onwards. - Easily works as a cluster, can be configured as active-passive or active-active which improves performance - It allows to perform maintenance, recovery of databases. - I have tested the installation and use in Windows 7 operating system and Debian version 6 to 8 and works without problems. - Likewise I have worked in postgres since its version 8.1 to 9.6.6 and a positive change has been noticed and performance improvements, but I insist on the point at which the databases should be fine designed.

Nachteile:

- Many people declare it as slow in insertions and updates compared to others Managers, however, that will depend on how well designed the database is. - For some, not having support online or with an official help center can be a big disadvantage. - It is advisable to have command knowledge to work on consoles and terminals to perform a good configuration

Aníbal M.
Aníbal M.
Programador in Venezuela
Verifizierter Nutzer auf LinkedIn
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

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

5 vor 4 Jahren

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

Vorteile:

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

Nachteile:

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.

Maryury P.
Maryury P.
DBA Especialista I in Venezuela
Verifizierter Nutzer auf LinkedIn
Bankwesen, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Database Manager PostgreSQL

4 vor 4 Jahren

Kommentare: In my experience using the software I really liked that it allows adding custom functions developed using different programming languages.
The integrity of the data and the referential integrity of the foreign key are maintained. It has allowed me, in an easy and secure way, the asynchronous replication of the databases for an alternative center in case of disasters.
I did not like it is that when I have any doubt about an error presented in the system where the database is working, I can not clarify it because there is no specific place to which, because and com solve the error.

Vorteile:

PostgreSQL allows to control high concurrency, offering security by domain definitions, who can access the database server, the backup copies of the database can be made completely or only a table, according to the request, restorations and tasks maintenance, in addition to replicate in case of disasters. It also allows to activate triggers to execute in tables or views in special cases or eventualities. It has a friendly graphical interface for the administrator, through which they can be done from the creation of the database, to execute query querys and updates of the data, if necessary, you can have details with the status tool of the server referring to the queries that are executed in the DB (if there are locks, duration, etc.). It allows the development of robust and efficient Databases

Nachteile:

There is no online or telephone support. Only official forums are available where users expose their doubts that other users of the community respond to, ademas it consumes many resources

Mark M.
Mark M.
Vice President of Information Technology in USA
Verifizierter Nutzer auf LinkedIn
Marktforschung, 11-50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Solid database that won't break the bank and won't let you down

5 vor 2 Jahren

Kommentare: We have never lost data, never paid too much and never looked back. PostgreSQL is at the hear of our organization and our trust has paid off in the long run. Running it on top of a managed stack such as AWS RDS is they way to go as this is the hardest part of using PostgreSQL and you don't want to waste time re-learning what has already been learned. It's worth the cost to use these services in the long run. Rapid prototyping can be done locally and is free so your price to start is always zero!

Vorteile:

PostgreSQL is and always has been one of the most feature rich and solid databases available. Its price / performance / feature set is simply unmatched in the industry today.

Nachteile:

There is a lot of old information on the internet that is no longer relevant to current versions and you must sift through this in some cases to find the modern and elegant solutions. It was touted as "slow" compared to MySQL in the early 2000's and much of that information is wrong due to lack of user experience with the product or no longer the case today.

Verifizierter Rezensent
Founder in Polen
Verifizierter Nutzer auf LinkedIn
Marketing & Werbung, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

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

5 vor 9 Monaten

Vorteile:

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

Nachteile:

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.

Moris M.
Moris M.
Colaborador Técnico in El Salvador
Verifizierter Nutzer auf LinkedIn
Staatsverwaltung, 5.001-10.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

PostgreSQL - Robustes y Seguridad en Bases de Datos

5 vor 2 Jahren

Kommentare: La fasilidad de hacer BKs configurar Jobs, analizar querys y definir data tables, triggres, referencias, entre otros hace del uso y experiencia de utilizar y administrar PostgreSQL muy satisfactoria.

Vorteile:

PostgreSQL ofrece un potente motor de bases de datos que brinda una robustes para la administración de BD ademas de una devirsificación de herramientas para trabajar con los Data Tables, triggers, punteros, etc, el análisis de querys permite al administrador porder determinar los aspectos donde deben mejorarse los querys.

Nachteile:

Las opciones de configuración y personalización que nos ofrece PostgreSQL si bien son muchas, hay algunas de mayor importancia y hay que configurarlas o setearlas hasta finalizado el proceso de instalación, siendo que podria incluirse en este proceso para que no se invierta tiempo en hacer estas personalizaciones o configuraciones minimas.

Diego C.
Diego C.
Technical Director in UK
Verifizierter Nutzer auf LinkedIn
Marktforschung, 2-10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

The database everyone should be using

5 vor 3 Jahren

Kommentare: PostgreSQL is an incredibly powerful piece of software that should be the RDBMS in every software project instead of less powerful but more famous alternatives.
Personally it will be my choice for every future project.

Vorteile:

PostgreSQL is so powerful, complete and stable. This should come with no surprise given the long history behind it. At the same time it's incredibly modern and supports new paradigms (like NoSQL, JSON data types) and it's also very simple to familiarize with.

Nachteile:

It's unbelievable how PostgreSQL is not as well-known as one of his competitors (MySQL) notwithstanding the fact that is so much more powerful.

Abdelhakim Z.
Abdelhakim Z.
PhD Researcher in Marokko
Verifizierter Nutzer auf LinkedIn
Bildungsmanagement, 2-10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

The best user tailored db experience.

5 vor 2 Jahren

Kommentare: I use PostgreSQL with almost every endeavor nowadays. Both at work and with personal projects, it is very robust when used in my research field which is optimization and operations research, but also flexible enough to help me quickly deploy web apps.

Vorteile:

PostgreSQL is by far the most user friendly and most advanced database system out of the top 5 popular choices. It's inherently relational making it easily compatible with ORMs, has many smaller quirks like jsonb storage, the WITH keyword, and a vast amount of data types. It's also one of the most dynamic DBMS as it releases major changes more than once a year, with an ecosystem that consistently adapts to these versions.

Nachteile:

Extensions in pgsql could use a bit of streamlining (extensions like pg_cron or similar), which was a bit complicated to do in with CI. Another concern would be some stability issues with the latest pgAdmin database interface, but in all fairness that isn't directly an issue with pgsql.

Verifizierter Rezensent
Software developer in Spanien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 2-10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Powerful database

5 vor 2 Jahren

Kommentare: Excellent database engine with a lof of features and great overall performance. It has a very huge community so you could get help very easily. I'd recommend to use it.

Vorteile:

Highly recommended. It's the most powerful database engine I ever worked with. It has a lot of features that I used and worked very well: postgis for spatial searches, full-text search, partitions, etc.

Nachteile:

At some point, we start having problems with very slow queries, and after some debugging we discover postgres decided to use the wrong index to perform the query plan. Probably because of bad stats but from time to time the problem happens again.

Juan manuel C.
Juan manuel C.
Web Developer in Argentinien
Verifizierter Nutzer auf LinkedIn
Verbraucherdienste, 51-200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

The Ultimate Database Engine

5 vor 6 Monaten

Kommentare: In general, my experience with postgress is more than satisfactory, it is an engine that works very well, it is stable, it allows me to handle large databases with tables of more than a million data without any problem. It has some syntax different from common sql, but they give great functionality (like data parsing)

Vorteile:

Excellent database manager, it has its own program (phAdmin) that gives you a very friendly graphical interface to carry out all kinds of tasks. Postgress is highly scalable and stable, which is why I prefer it over other options

Nachteile:

As against, when the database that is handled is relatively small, when comparing response speeds with other engines, it has a small disadvantage, but its great advantage is noted by having a large database.