PostgreSQL/Features

From Wikibooks, open books for an open world
Jump to navigation Jump to search
Introduction to PostgreSQL PostgreSQL
Features
Featured Platforms



PostgreSQL offers a wide range of functionalities:

General[edit]

  • Conformance with the SQL standard
  • Guarantee for the ACID paradigm
  • Full support for parallel running transactions in multiuser environments by an implementation of a multi version control system (MVCC). All isolation levels, including Serializable
  • Rich data type and operator system; strong constraints
  • Extensibility mechanism for data types and operators, e.g.: spacial data, special indices, ... (used by PostgreSQL itself)

Reliability, Replication[edit]

  • Online backup
  • Point-in-Time Recovery
  • Physical replication (complete cluster) as well as logical replication (parts of cluster or database) with synchronous or asynchronous behaviour
  • Hot standby as fallback strategy or to distribute read-load across multiple server

Advanced Features[edit]

  • Table partitioning
  • Query optimizer; parallel execution of queries
  • Access to external data (Foreign Data Wrapper): other database systems, CSV file, ... [1]
  • Trigger, procedural language, stored procedures
  • A Notification System
  • Full-text search

Soft Skills[edit]

  • Free and Open Source [2]
  • Runs on major platforms: Linux/Unix/BSD, macOS, Windows [3]
  • Excellent documentation [4]
  • Continuous development of new features
  • Huge and agile community [5]
    • Chats, Mailing Lists, Blogs
    • Additional (free and commercial) tools: bidirectional replication, managing of a huge number of clusters, pooling [6]
    • Wiki [7]

References[edit]


Introduction to PostgreSQL PostgreSQL
Features
Featured Platforms