Save to My Lists

PostgreSQL Features

What are the features of PostgreSQL?

Database Features

  • Storage
  • Availability
  • Stability
  • Scalability
  • Security
  • Data Manipulation
  • Query Language

Support

  • Text Search
  • Data Types

Security

  • Database Locking
  • Access Control

Performance

  • Data Concurrency
  • Advanced Indexing

Management

  • Data Schema
  • Query Language

Top Rated PostgreSQL Alternatives

PostgreSQL Categories on G2

Filter for Features

Database Features

Storage

This feature was mentioned in 435 PostgreSQL reviews.
89%
(Based on 435 reviews)

Availability

This feature was mentioned in 440 PostgreSQL reviews.
90%
(Based on 440 reviews)

Stability

444 reviewers of PostgreSQL have provided feedback on this feature.
90%
(Based on 444 reviews)

Scalability

Based on 426 PostgreSQL reviews.
86%
(Based on 426 reviews)

Security

As reported in 415 PostgreSQL reviews.
87%
(Based on 415 reviews)

Data ManipulationView full feature definition

See feature definition
This feature was mentioned in 429 PostgreSQL reviews.
88%
(Based on 429 reviews)

Query Language

435 reviewers of PostgreSQL have provided feedback on this feature.
90%
(Based on 435 reviews)

Support

Text Search

Provides support for international character sets and full text search. This feature was mentioned in 88 PostgreSQL reviews.
85%
(Based on 88 reviews)

Data Types

Based on 99 PostgreSQL reviews. Supports multiple data types like primitive, structured, document etc.
92%
(Based on 99 reviews)

Languages

Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. This feature was mentioned in 87 PostgreSQL reviews.
92%
(Based on 87 reviews)

Operating Systems

Available on multiple operating systems like Linux, Windows, MacOS etc. This feature was mentioned in 88 PostgreSQL reviews.
91%
(Based on 88 reviews)

Security

Database Locking

Prevents other users and applications from accessing data while it is being updated to avoid data loss or update. This feature was mentioned in 89 PostgreSQL reviews.
87%
(Based on 89 reviews)

Access Control

As reported in 91 PostgreSQL reviews. Allows permissions to be granted or revoked in the database, schema or table levels.
90%
(Based on 91 reviews)

Encryption

Built-in native encryption with enterprise key management. 83 reviewers of PostgreSQL have provided feedback on this feature.
86%
(Based on 83 reviews)

Authentication

Provides multi-factor authentication with certificates. 87 reviewers of PostgreSQL have provided feedback on this feature.
89%
(Based on 87 reviews)

Performance

Disaster Recovery

Provides data recovery functionality to protect and restore data in a database. This feature was mentioned in 82 PostgreSQL reviews.
86%
(Based on 82 reviews)

Data Concurrency

As reported in 88 PostgreSQL reviews. Allows multi-version concurrency control.
88%
(Based on 88 reviews)

Workload Management

Based on 85 PostgreSQL reviews. Handles workloads, from single machines to data warehouses or web services with many concurrent users.
86%
(Based on 85 reviews)

Advanced Indexing

Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. This feature was mentioned in 88 PostgreSQL reviews.
88%
(Based on 88 reviews)

Query Optimizer

Based on 85 PostgreSQL reviews. Helps interpret SQL queries and determine the fastest method of execution.
86%
(Based on 85 reviews)

Management

Data Schema

Data is organized as a set of tables with columns and rows like a table structure. This feature was mentioned in 96 PostgreSQL reviews.
92%
(Based on 96 reviews)

Query Language

Allows users to create, update and retrieve data in a database. This feature was mentioned in 94 PostgreSQL reviews.
92%
(Based on 94 reviews)

ACID - Complaint

Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties. 83 reviewers of PostgreSQL have provided feedback on this feature.
90%
(Based on 83 reviews)

Data Replication

Provides log-based or/and trigger-based replication. 87 reviewers of PostgreSQL have provided feedback on this feature.
89%
(Based on 87 reviews)