# Page 4 | PostgreSQL Reviews 2026. Verified Reviews, Pros & Cons | Capterra

> Page 4 - Is PostgreSQL the right Database solution for you? Explore 412 verified user reviews from people in industries like yours to make a confident choice.

Source: https://www.capterra.com/p/48791/PostgreSQL/reviews

---

PostgreSQL

4.6 (412)

[View alternatives](https://www.capterra.com/p/48791/PostgreSQL/alternatives/)

Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team. [Learn more](https://www.capterra.com/our-story/)

* * *

Last updated March 25th, 2026

# Page 4 - Reviews of PostgreSQL

## Showing most helpful reviews

Showing 76-100 of 412 Reviews

Sort by:

Most Helpful

Rating

Company Size

Reviewer's Role

Length of Use

Frequency of Use

Trang N.  
Senior Test Engineer  
Computer Software  
Used the software for: 2+ years

### "Best ORDBMS with full support of stored procedures and triggers"

December 29, 2019

5.0

We use PostgreSQL as the main database in our system which we need in our system to processing and does an additional task at the database level and frequency need to use complex SQL which needs to join between the table and View. With PostgreSQL we could store the whole of our JSON object instead of breaking down to field like other sequence databases

Pros

PostgreSQL provides the complex functions in its stored procedures and triggers. PostgreSQL also works well in the JSON file, it allows us to store, search and index by JSON content data. It provides privileges at the object level to User and Role to make data more secure. It has many advance SQL command like Table joins, Subquery and Views, the performance of PostgresSQL is greate when we need to execute complex SQL command

Cons

It does not cache the Query execution plans so sometimes cause a delay when we need to run SQL repeatedly. Its UI tool, PgAdmin's is not good compared with other tools that lack some function of the search or Scrolling.

Review Source

ritesh T.  
Senior Software Engineer  
  
Used the software for: 2+ years

### "Wanted to use an open source object-relational database for our project and postgres worked well"

June 30, 2018

5.0

Pros

1)Easy installation with good user guide 2)Scales pretty well for big applications 3)Support for high availability can be easily implemented by going through the documentation 4)Have yet to find any database related issues in our application since the time application was launched 5)Good Java-sql mapping of data types 6)Works wonders with JPA implementations 7)Postgresql's query optimiser is one of the best i have seen so far

Cons

Again since the software has so much to offer it can be sometime hard to learn all the features.Other than that there is no cons as such

Review Source

Prudencia F.  
Technician in Energy and Thermal Engineering  
Research  
Used the software for: 1-2 years

### "PostgreSQL Review"

February 20, 2023

4.0

Pros

PostgreSQL is an excellent choice for working with relational databases. After extensive experience with databases, I found that PostgreSQL is one of the most reliable options. It is the preeminent open source SQL system and potentially the best of all, open source or not. PostgreSQL offers both remarkable performance and dependability.

Cons

The SQL syntax for Postgresql was slightly different than what I was used to.

Review Source

Petr V.  
Developer  
Computer Software  
Used the software for: 6-12 months

### "Object-relational open source database"

July 22, 2019

4.0

We use PostgreSQL mainly for heavy load projects because to high write performance due to its MVCC approach, it largely eliminates the need for locking, and that the database effectively meets ACID principles.

Pros

Supports functions where the results are suitable for use as with tables. We can define own aggregate and window functions on that. Includes built-in support for B + tree, hash, GiST, GiN and custom index types. Support access using a system known as Multi-Version Concurrency Control (MVCC). Native support for many data types including XML support for Xpath queries or UUID. User defined objects, posibility to create new types of almost all objects in the database.

Cons

Possible worse performance in read operation.

Review Source

ravi R.  
Associate Software Developer  
Computer Software  
Used the software for: 6-12 months

### "Very simple yet powerful"

December 24, 2018

4.0

It has helped us to remove unnecessary distractions and focus on the main task of reducing time taken for queries. It is very fast and reliable with it's transactions. It helped us with high volumes of data. Postgres FDW was used to connect our existing SQL server databases.

Pros

It has a clean interface and does not tries to get an attractive UI for you. It has very less query time. It provides a good architecture for code first approach projects. We set it up on Linux and it does behaves pretty nice on it. We get to see what what we need to see while querying. It is quiet easy to edit the datatypes and design your schema. Also it provides some nice mining tools which can operate on our data. And the best thing about it is source code availability. We can do whatever we want.

Cons

It is slow for small database sizes but the issue erodes with database size increase. Also it has different syntax which might look complex to some.

Review Source

VR

Verified Reviewer  
Information System Administrator  
Financial Services  
Used the software for: 6-12 months

### "Good RDMS Application for the Students "

August 14, 2022

5.0

Best part is that this can cover by their own triggers , functions datatypes that can be very easy to managed dbs specially like open sources that can be use without any cost effective

Pros

Most of the likely fetcher is multi language support like Java, PHP, C++ , C , Perl, Python, etc.

Cons

when we considering large DBs like data warehouse large number of data reading needed but this is having low reading speed by comparing other rdms applications

Review Source

Cristian V.  
Software Developer  
Telecommunications  
Used the software for: 2+ years

### "The best relational database out there. Period."

December 5, 2019

5.0

We use postgreSQL whenever we can. In our projects in python or elixir we use it as our relational database of choice, and it has not disappointed. It has some domain specific features that can help you keep everything centralized, like document support (json) or full text search (search engine). If you have not tried it, go ahead and do it!

Pros

Stable, resilient, fast. It has everything you could need from a relational database plus more. We have worked on really big databases with no issues when using postgresql.

Cons

There are some differences in syntax to other SQL databases, but overall they are not hard to understand and learn.

Review Source

Gedson S.  
Senior Production Engineer  
Telecommunications  
Used the software for: 2+ years

### "A solid and reliable relational database"

March 12, 2019

4.0

We've used PostgreSQL as a RDS in several projects, with great results. Its very reliable and robust, which are the best facets you look for in a database.

Pros

PostgreSQL has great support for many data types, including JSON. This makes it a very flexible RDB, because you can integrate schema-free documents in your tables, query on the and select their properties. PG 11 also brought a high performance parallel query engine, which greatly boost it's performance.

Cons

Security and encryptions features have room for improvement, but you can count on some 3rd party plug-ins to fill the gap.

Review Source

VR

Verified Reviewer  
Site Reliability Engineer  
Computer Software  
Used the software for: 2+ years

### "Nothing but praise for \*the\* SQL DBMS"

December 11, 2019

5.0

We are running tens of Postgres databases and we have no reason to switch.

Pros

It's been reliable beyond all expectations. Put your data in Postgres, you know you'll find them when you need them.

Cons

VACUUMs are a big performance penalty, and the default auto-vacuum settings aren't always optimal for all use cases.

Alternatives considered

[MySQL](https://www.capterra.com/p/11482/MySQL/)

Reason for choosing PostgreSQL

It's more performant, stable and has more features.

Review Source

Hasan S.  
T24 Technical Analyst  
Banking  
Used the software for: Less than 6 months

### "PostgreSQL Database Management Tool"

June 26, 2021

4.0

I used PostgreSQL for small scale project and it's main benefit is that it is a perfect tool for small and medium sized projects. It has the ability to maintain history of queries which is an amazing feature.

Pros

PostgreSQL has many features and functions and is comparatively much faster than MySQL. It is free but very useful and secure tool in managing big databases. It has built-in data types that makes the work of a developer much easier. It has the ability to handle complex queries and process them within seconds. The best feature that I have found is storing data as advanced data structures such as Lists and JSON. It is a bit difficult to learn.

Cons

Sometimes it is very difficult to resolve errors because of the lack of documentation. Also, having aliases for nested queries is an overhead when migrating from different databases. Installation is also difficult as compared to MySQL.

Review Source

VR

Verified Reviewer  
Systems Engineer  
Computer Software  
Used the software for: 2+ years

### "Easy to setup and configure..."

December 17, 2018

5.0

Very positive. It's a lightweight DB suite that has a ton of power and flexibility.

Pros

I really love how easy it is to setup PostgreSQL without having a ton of knowledge about the product. Setting it up on Windows is a breeze (even easier than Microsoft SQL), and you're up and running within 10 minutes. There are also some graphical tools that you can install that allow you to easily manage your PostgreSQL instances via a GUI if you prefer that over a command line interface.

Cons

Sometimes it can be tough due to version differences to get the proper ODBC connector installed on your Windows box. You end up with multiple connectors that all have slightly different versions, and your application must be sure to specify the exact correct version otherwise it could throw errors. It would be nice if the connectors just stuck with major versions that supported all of the minor releases in that branch.

Review Source

HM

Hussein M.  
Software Engineer  
Retail  
Used the software for: 1-2 years

### "Powerful and Reliable"

May 5, 2023

5.0

Pros

One of the best pros that made me switch to postgres was the performance, it has an excellent performance for complex queries and has support advanced indexing techniques. As well as the extensibility, reliability and being open source of course.

Cons

Lack of built-in sharding,n PostgreSQL does not have built-in sharding capabilities, which may make it more challenging to scale out horizontally across multiple servers.

Review Source

Cristiano D.  
sistemista / programmatore  
Information Technology and Services  
Used the software for: 2+ years

### "Very reliable database"

October 18, 2018

5.0

PostgreSQL is a very reliable, stable and quick RDBMS. In my experience it has no problems managing hundreds of millions of records. From a DBA point of view, has a very low TCO since once configured it seldomly needs further intervention by the DBA. It comes with PostGIS plugin, so it is very easy to manage geographical data types

Pros

A very powerful RDBMS at the best price point: free Integrated with spatial extension PostGIS Very quick and stable, it manages flawlessly hundreds of millions of records

Cons

Table partitioning is limited Multimaster replicas are available only through a third party distribution

Review Source

Morgan C.  
CIO  
Information Technology and Services  
Used the software for: 2+ years

### "De facto RDBMS for the Internet"

August 17, 2018

5.0

We have run many sites on PostgreSQL with Django at high performance. We use NoSQL where appropriate, but in every case we have still used Postgres for the main data store, and used the key value stores for caching and queueing.

Pros

PostgreSQL is open source. We use it for pretty much every site or system we build. It scales well and needs a minimum of tuning. We only fall back to MySQL when absolutely necessary.

Cons

We still encounter software which can only run on MySQL, especially PHP applications. For those we'll tolerate MySQL but otherwise we would prefer PostgreSQL support.

Review Source

GC

Goran C.  
Solution Architect  
Information Technology and Services  
Used the software for: 2+ years

### "Best open source database for enterprises"

September 29, 2022

4.0

We use PostgreSQL as RDMS for our custom made solution for customers\\projects without dedicated enterprise RDMS.

Pros

It supports advanced database features like partiotions, scalability, optimized concurrency management, security. It is offered under MIT-style license.

Cons

It is difficult to troubleshoot PostgreSQL. Not as widely used as My SQL for example, not as active community

Alternatives considered

[MySQL](https://www.capterra.com/p/11482/MySQL/)

Reason for choosing PostgreSQL

PostgreSQL is more advanced and offers more

Switched from

[MySQL](https://www.capterra.com/p/11482/MySQL/)

PostgreSQL is more advanced and offers more

Review Source

VR

Verified Reviewer  
Software Analyst  
Computer Software  
Used the software for: 2+ years

### "A great but undocumented relational DBMS"

December 4, 2019

4.0

In developing an application, it was necessary to develop an associated application and a database for storing and presenting this data. We opted for Postgre because of its robustness and ease of use.

Pros

The fact that it is a code DBMS makes it very transparent and adaptable to business needs. This was a very important factor for its adoption in our projects.

Cons

I feel that although it is widely used in medium to high level projects, Postgre does not have the proper documentation focus required. And that makes it somewhat discredited when planning an application.

Review Source

Jose G.  
Consultor Java Senior  
Computer Software  
Used the software for: 2+ years

### "PostgresSQL And web development"

August 17, 2018

4.0

I have used PostgresSQL in my Java Web developments with absolute confidence as its results are as expected in terms of data manipulation.

Pros

PostgresSQL is a pretty good product as it allows with an easy installation to access the functionalities of a powerful database manager without sacrificing disk space and ram memory. On the other hand, the fact of using standard SQL ansi provides users with a known syntax.

Cons

In my personal experience postgresSQL does not work well with large volumes of data and it can be tedious to use stored procedures.

Review Source

Eyamir del Valle U.  
Ingeniero en Informática  
  
Used the software for: 2+ years

### "It is a fairly complete database manager, with a lot of functionality and a lot of documentation. Be"

March 23, 2018

5.0

It really is a fairly robust database manager, which allows an excellent data management and a quite complete security implementation, as well as the implementation of procedures that allow to take care of the integrity of the data easily.

Pros

its easy use, the robustness in the implementation of the security of the database. Its great functionality, which allows safe and easy use of data.

Cons

Actually up to now I have not found features that I do not like. The only thing is that sometimes it is a little complicated to get hosting that provide the service for PostgreSQL

Review Source

Denis V.  
MS SQL Server DBA  
  
Used the software for: 2+ years

### "PostgreSQL free RDBMS."

March 22, 2018

4.0

This RDBMS can be used in various scenarios, probably more suitable for hosting site data, stable in operation, quickly works with large databases.

Pros

In General, a good performance suitable for systems with weak iron. The system as a whole works very steadily. Flexibly customizable functionality plus extensive plugin support. Large community. The presence of integration with ETL solutions pleases us. I would also like to mention the SQL editor, which implements syntax highlighting in different colors, which gives excellent readability of the code. And the most basic and the main thing is that it is a free open source database management system.

Cons

Not very suitable for beginners, requires significant additional time spent on the study. It does not have high availability solutions, nor does it have clustering. Difficult to install and configure. Not very well written documentation.

Review Source

Juanito O.  
Web Developer  
Computer Software  
Used the software for: 6-12 months

### "Un gran rendimiento para proyectos robustos"

July 27, 2021

5.0

Pros

Me encanta que es una de las mejores base de datos relacional del mercado, usamos PostgreSQL para nuestros proyectos de desarrollo web, ofrece estabilidad y escalabilidad.

Cons

Un poco confusa la instalación, tuve algunos percances en su despliegue, pero fue más por mi desconocimiento.

Alternatives considered

[MySQL](https://www.capterra.com/p/11482/MySQL/)

Reason for choosing PostgreSQL

Su mejor rendimiento en proyectos que demandan estabilidad y escalabilidad.

Switched from

[MySQL](https://www.capterra.com/p/11482/MySQL/)

Ofrece mejor soporte para proyectos más robustos.

Review Source

VR

Verified Reviewer  
Software Engineer  
Computer Software  
Used the software for: 2+ years

### "PostgreSQL is a very robust free SQL Database option"

May 14, 2020

5.0

Overall PostgreSQL has been a very good option for our uses, and has worked very well for queries both big and small.

Pros

PostgreSQL is a very advanced SQL Database with a lot of advanced features, and it's free which is great. It scales well and works very well for large databases.

Cons

PostgreSQL doesn't have loose indexscan like other SQL options. It's not a dealbreaker, but it does require you to create a pretty complex query to be able to do a quick index skip scan (get a list of all unique values in a given index).

Review Source

VR

Verified Reviewer  
Business Development and Strategy  
Internet  
Used the software for: 1-2 years

### "The best database for any startup"

October 29, 2019

5.0

Over PostgreSQL has been very good. It is a lightweight and efficient database. I would recommend it for any startup.

Pros

PostgreSQL is the first database that I learned and I have stuck with it ever since. I have used it several times for small projects, and it my previous startup. The response time is fast, the database is efficient, and very easy integrate with any back-end framework. I have mainly integrated PostgreSQL with Django and it works very efficiently and is extremely easy to debug.

Cons

I wish there was a bit more support in the community for PostgreSQL. You have find most of your answers if you ask on public forms but I have seen progress in the community.

Review Source

PK

Pranav K.  
Senior Consultant Development  
Computer Software  
Used the software for: 2+ years

### "Best choice for Relation Databases"

June 16, 2023

5.0

Pros

It provides additional data types than traditional MySQL database. Easy deployment and faster write operation with massive dataset really makes it best choice among the open source RDBMS.

Cons

No major cons, I faced as of now for PostgreSQL

Review Source

Chris D.  
Senior Software Developer  
Computer Software  
Used the software for: 2+ years

### "One of the many free but well supported Database products out there."

December 6, 2018

5.0

Pros

PostgreSQL is one of the most simple to install database systems out there. It supports all standard ansi sql types, and is stable enough to use in production without having to splash out on professional support at extensive costs. Getting support can assist in business uses though, but either way, it works well for basic SQL and data storage.

Cons

The package types for advanced management are non-standard and can be a bit of a learning curve if coming from Oracle PLSQL or Microsoft T-SQL

Review Source

VR

Verified Reviewer  
IT Support Technician  
Law Practice  
Used the software for: 2+ years

### "A great free solution"

June 5, 2019

5.0

A great, free solution that is easy to use once you get the hang of it. In fact, you don't really have to write any SQL at all to create, modify and add things to your database.

Pros

I love that this software is free. It has an easy to use interface, especially with the more recent updates. It is very easy to find your databases, and create new tables and fields within them.

Cons

There is a steep learning curve when it comes to SQL, but that is the same with any "programming" language. It is something that gets easier over time.

Review Source

Similar Products

Featured