User:Dirk Hünniger/PostgreSQL

= Major Features =

= Supported Platforms =

= Download, Installation =

= Managing the Instance =

= DBA Tools: psql, pgAdmin, phpAdmin, ... =

= Configuration =

= Backup & Recovery =

= Architecture: Collaboration of Processes, RAM, and Files =

= The logical Perspective: Cluster, Database, Schema =

= The physical Perspective: Directories and Files =

= Transactions =

= The ACID Paradigm =

= Visibility of Rows: Isolation Levels =

= Multiversion Concurrency Control (MVCC): Implementation of the ACID Paradigm =

= Vacuum =

= Wraparound and Freeze =

= Visibility Map and Free Space Map =

= Write-Ahead-Log (WAL) =

= Client-Server Communication: The Client Side =

= Client-Server Communication: The Server Side =

= Security within the Database: Roles, Users, Privileges =

= Replication =

= Partitioning =

= Tablespace =

= Upgrade =

= Glossary / Prominent Terms =

= The Extension Mechanism =

= PostGIS - Spatial Data =

= Foreign Data Wrappers =

= BDR: Bidirectional Replication =

= Page Layout for Data and Index Files =

= Indices =

= B-tree =

= GIN =

= BRIN =

= Hash =