< PostgreSQL


PostgreSQL offers a wide range of functionalities:

General

  • 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

  • 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

  • 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

  • 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

  1. ↑ https://wiki.postgresql.org/wiki/Foreign_data_wrappers
  2. ↑ https://www.postgresql.org/about/licence/
  3. ↑ https://www.postgresql.org/download/
  4. ↑ https://www.postgresql.org/docs/current/static/index.html
  5. ↑ https://www.postgresql.org/community/
  6. ↑ https://www.postgresql.org/download/product-categories/
  7. ↑ https://wiki.postgresql.org/


This article is issued from Wikibooks. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.