# What are the advantages and disadvantages of PostgreSQL?

What are the advantages and disadvantages of PostgreSQL?

##### Post Metadata
- Posted at: about 4 years ago
- Author title: Pinned by G2 as a common question



## Comments
### Comment 1

Open Source: PostgreSQL is free and open-source software, meaning anyone can download, use, and modify it as needed without licensing costs.  
SQL Compliance: PostgreSQL has high compliance with the SQL standard and supports many advanced SQL functionalities.  
Extensibility: Users can define their own data types, operators, functions, and can even write code in different programming languages without relying solely on SQL.  
Support for Advanced Features: It supports features like transactions, subselects, triggers, views, referential integrity, and many others.  
Data Type Support: In addition to standard data types, PostgreSQL supports several other types, such as arrays, hstore (for storing key-value pairs), JSON, and JSONB, to work directly with data in JSON format, among others.  
MVCC (Multi-Version Concurrency Control) Concurrency: This allows multiple transactions to be executed concurrently without blocking each other.  
Extensions and Add-ons: There are many plugins and extensions available for PostgreSQL, which add functionalities like full-text search, geospatial, among others.

##### Comment Metadata
- Posted at: almost 3 years ago
- Author title: Analytics Engineer | Data Analyst | Azure Analyst | Business Intelligence



### Comment 2

Advantages: A different resource for your SQL needs without the tag of a legacy system

##### Comment Metadata
- Posted at: about 3 years ago
- Author title: Industrial AI || Digital Twin || Building Sustainable Future




## Related Product
[PostgreSQL](https://www.g2.com/products/postgresql/reviews)

## Related Category
[Relational Databases](https://www.g2.com/categories/relational-databases)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4