PostgreSQL
About PostgreSQL
PostgreSQL is an open-source relational database management system (RDBMS), which helps businesses store, manage, and scale data workloads, from single machines to data warehouses with multiple concurrent users. Features include materialized views, stored procedures, indexing, multi-factor authentication, full-text search, and event triggers.
The ACID-compliant system lets developers define data types such as numeric, date/time, array, or geometry, build custom functions, and maintain data integrity using exclusion constraints, explicit locks, and primary or foreign keys. Database administrators can utilize SQL to perform multiple data operations such as INSERT, UPDATE, DELETE, and more. Using foreign data wrappers, IT professionals can access external databases or streams for querying.
PostgreSQL maintains a write-ahead log (WAL), which helps developers record file changes and restore databases during system crashes. Administrators can grant role-based objects and column to table level permissions. Developers can also improve query performance on tables by using acceleration partition pruning, automatically invalidate cached execution plans, write background checkpoints, and restrict bandwidth usage for backup processes.
Images
Not sure about PostgreSQL?
Compare with a popular alternative
Starting Price
Pricing Options
Features
Integrations
Ease of Use
Value for Money
Customer Service
Alternatives
ArcGIS
Microsoft Access
Amazon Aurora
Oracle E-Business Suite
Reviews
Already have PostgreSQL?
Software buyers need your help! Product reviews help the rest of us make great decisions.
- Industry: Computer Software
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
PostgreSQL - A World Class DBMS that you can have for free
Reviewed on 2021/03/11
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.
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 Switching to 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.- Industry: Computer & Network Security
- Company size: 51–200 Employees
- Used Weekly for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
"PostgreSQL: Ease and Efficiency in Application Development
Reviewed on 2023/10/23
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
Pros
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.
Cons
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
- Industry: Computer Software
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 6.0 /10
database alternative to mysql
Reviewed on 2019/09/26
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
Pros
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
Cons
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
- Industry: Electrical/Electronic Manufacturing
- Company size: 2–10 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
PostgreSQL is an Open Source tool of the highest caliber for Database Management.
Reviewed on 2023/09/15
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.
Pros
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.
Cons
One of the drawback of the PostgreSQL is CPU usage is rather high.
- Industry: Hospital & Health Care
- Company size: 1,001–5,000 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 8.0 /10
Quality review of PostgreSQL
Reviewed on 2023/09/29
Pros
- Good management of data tables & possibility to have service of multiple Servers
Cons
- Great to improve user interface & SQL query error classification to make easy accessibilities of data.
PostgreSQL FAQs
Below are some frequently asked questions for PostgreSQL.Q. What type of pricing plans does PostgreSQL offer?
PostgreSQL offers the following pricing plans:
- Starting from: US$0.01/one-time
- Pricing model: Free Version
- Free Trial: Available
PostgreSQL is available for free.
Q. Who are the typical users of PostgreSQL?
PostgreSQL has the following typical customers:
Self Employed, 2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000
Q. What languages does PostgreSQL support?
PostgreSQL supports the following languages:
English
Q. Does PostgreSQL support mobile devices?
PostgreSQL supports the following devices:
Q. What other apps does PostgreSQL integrate with?
We do not have any information about what integrations PostgreSQL has
Q. What level of support does PostgreSQL offer?
PostgreSQL offers the following support options:
Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support, 24/7 (Live rep)
Related categories
See all software categories found for PostgreSQL.
