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
DBeaver
Reviews
Already have PostgreSQL?
Software buyers need your help! Product reviews help the rest of us make great decisions.
- Industry: Computer Software
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Powerful database
Reviewed on 18/04/2022
We use PostgreSQL as database tool for all our healthcare software products
We use PostgreSQL as database tool for all our healthcare software products
Pros
PostgreSQL is eaiser to maintenance and to install than other RDBMS like ORACLE. PostgreSQL is open source so is cheaper than other RDBMS. It takes less learrning time than other RDBMS
Cons
We do not have any cons about PostgreSQL
- Industry: Logistics & Supply Chain
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 10.0 /10
Best open-source RDBMS out there
Reviewed on 06/06/2022
Overall, we have a very productive experience with PostgreSQL. Whenever we need a backend database...
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.
Pros
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.
Cons
I don't have anything I dislike about PostgreSQL.
Reasons for Choosing PostgreSQL
For some tools we deployed, we naturally needed to scale up and handle more complex workloads. So we changed our backend database.Switched From
SQLiteReasons for Switching to PostgreSQL
Out of many open-source tools we deploy, PostgreSQL is the most widely supported DB backend among others. So we decided to use PostgreSQL whenever applicable.
- 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 26/09/2019
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: Renewables & Environment
- Company size: 11–50 Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
PostgreSQL Review
Reviewed on 25/09/2023
I highly recommend PostgreSQL, i have been using it at work and at the university
I highly recommend PostgreSQL, i have been using it at work and at the university
Pros
First, it is open source and wildly used database, it is customizable and scalable
Cons
It does not contain a customer service because it is open source but of course you can find ur answers on the internet and platforms
Alternatives Considered
MySQL- Industry: Computer Software
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
The right database for 95% of use cases
Reviewed on 01/05/2020
Postgres is there for you whenever you need to store and retrieve simple tabular data. Whether...
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 Switching to 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.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:
- 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.
