PostgreSQL

by Wikibooks contributors

Read here Read at Wikibooks

A book Wikibooks counts as complete, from its open-content textbook collection.

Description from Wikibooks.

Publisher
Wikibooks contributors
Subjects
Database management systems, Open source software, SQL
Licence
CC BY-SA 4.0, as Wikibooks states it
Who can read
Tweens profiles and older, judged from its title and subjects

Contents

  1. PostgreSQL
  2. printable version
  3. Major Features
  4. Supported Platforms
  5. Download, Installation
  6. Managing the Instance
  7. DBA Tools: psql, pgAdmin, phpAdmin, ...
  8. Configuration
  9. Backup & Recovery
  10. Architecture: Collaboration of Processes, RAM, and Files
  11. The logical Perspective: Cluster, Database, Schema
  12. The physical Perspective: Directories and Files
  13. Transactions
  14. The ACID Paradigm
  15. Visibility of Rows: Isolation Levels
  16. Multiversion Concurrency Control (MVCC): Implementation of the ACID Paradigm
  17. Vacuum
  18. Wraparound and Freeze
  19. Visibility Map and Free Space Map
  20. Write-Ahead-Log (WAL)
  21. Client-Server Communication: The Client Side
  22. Client-Server Communication: The Server Side
  23. Security within the Database: Roles, Users, Privileges
  24. Replication
  25. Partitioning
  26. Tablespace
  27. Upgrade
  28. Glossary / Prominent Terms
  29. The Extension Mechanism
  30. Page Layout for Data and Index Files
  31. Indices
  32. B-tree
  33. GIN
  34. BRIN
  35. Hash