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


Read More

Supported Operating System(s):

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

303 Reviews of PostgreSQL

Average User Ratings

Overall

4.63 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(198)

198

4 stars

(99)

99

3 stars

(6)

6

2 stars

(1)

1

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 303 results

June 2021

User Profile Picture

Janne from Telia Company AB

Verified Reviewer

Company Size: 10,000+ employees

Industry: Telecommunications

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 2021

One of the best overall databases in the market

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

Pros

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.

Cons

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.

Reasons for Choosing PostgreSQL

Best direct support from backend frameworks such as Django.

Reasons for Switching to PostgreSQL

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

March 2021

User Profile Picture

Jorge from Gatoware, LLC

Verified Reviewer

Company Size: 2-10 employees

Industry: Computer Software

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 2021

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

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.

Pros

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.

Cons

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

Reasons for Choosing 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.

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 .

June 2020

User Profile Picture

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.

Reasons for Switching to PostgreSQL

To handle more data and guarantee its integrity.

June 2021

Abbas Yusufzai from Bahria University Islamabad

Company Size: 51-200 employees

Industry: Oil & Energy

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

June 2021

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

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.

Pros

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.

Cons

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.

Reasons for Switching to PostgreSQL

It is a more comprehensive and equipped tool than mySQL and offers a lot more features and funtions and features than it.