About PostgreSQL

PostgreSQL is an open-source database management solution that helps businesses streamline operations related to indexing, performance tracking, data replication and more on a centralized platform. It enables employees to configure stop words, synonyms, thesaurus, Ispell and Snowball dictionaries to optimize full-text search processes.

PostgreSQL's partitioning and inheritance module allow supervisors to split large tables into smaller sections, improving overall query performance. Administrators can configure access rights, set up column and row-level security and use multi-factor authentication methodology to ensure a secure user experience. Additionally, data analysts can handle data backup, restoration and integrity operations using multiple methodologies...


Read More

Supported Operating System(s):

Windows 7, Mac OS, Linux, Solaris, Web browser (OS agnostic), Windows 8, Windows 10

264 Reviews of PostgreSQL

Average User Ratings

Overall

4.62 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(172)

172

4 stars

(85)

85

3 stars

(6)

6

2 stars

(1)

1

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 264 results

March 2020

Tigran from Information Technology and Services

Verified Reviewer

Company Size: 11-50 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

March 2020

PSQL databse.

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

Pros

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.

Cons

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.

June 2020

Adolfo from Ministry of Health, Gouverment of El Salvador

Verified Reviewer

Company Size: 10,000+ employees

Industry: Government Administration

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

3.0

Functionality

5.0

June 2020

Very complete and stable database

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

Pros

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

Cons

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

Reasons for Choosing PostgreSQL

For its flexibility for all types of projects, its price, and its stability.

March 2018

Albernes from MppTT

Verified Reviewer

Time Used: Less than 12 months

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

1.0

Functionality

3.0

March 2018

easy to use and understand

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

Pros

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

Cons

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 .

May 2020

Anonymous

Verified Reviewer

Company Size: 201-500 employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

3.0

Functionality

4.0

May 2020

The right database for 95% of use cases

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.

Pros

- 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!

Cons

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.

Reasons for Choosing PostgreSQL

I picked Postgres over MySQL is not as battle tested and was behind Postgres in terms of JSON object support. I picked Postgres over MongoDB because it's easier to set up, didn't have anyone else on the team that knew how to use it (whereas all 5 of my teammates have Postgres experience), and because Postgres can handle our traffic currently.

April 2020

Moris from Corte Suprema de Justicia

Verified Reviewer

Company Size: 5,001-10,000 employees

Industry: Government Administration

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

April 2020

PostgreSQL - Robustes y Seguridad en Bases de Datos

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.

Pros

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.

Cons

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.

Reasons for Choosing PostgreSQL

Mayor relación Calidad - Precio, soporte por la comunidad internacional, robustes y seguridad