# postgres/postgres

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/postgres-postgres).**

20,076 stars · 5,433 forks · C · other

## Links

- GitHub: https://github.com/postgres/postgres
- Homepage: https://www.postgresql.org/
- awesome-repositories: https://awesome-repositories.com/repository/postgres-postgres.md

## Description

PostgreSQL is an object-relational database management system designed for the persistent storage and retrieval of structured information. It functions as an ACID-compliant database server, utilizing standard query language protocols to maintain data consistency and reliability across large-scale application datasets.

The system distinguishes itself through an extensible architecture that allows for the definition of custom data types, operators, and indexing methods. It employs multi-version concurrency control to enable simultaneous read and write operations without blocking, supported by a cost-based query optimizer that evaluates statistical data to determine efficient execution paths.

The engine manages data integrity through strict logical rules and constraints, ensuring accuracy across interconnected information sets. It utilizes write-ahead logging to guarantee durability during system failures and maintains a shared buffer cache to minimize disk input and output operations during concurrent access.

## Tags

### Data & Databases

- [Relational Database Management Systems](https://awesome-repositories.com/f/data-databases/relational-database-management-systems.md) — Provides a high-performance object-relational database engine for persistent storage and retrieval of structured information.
- [Relational Databases](https://awesome-repositories.com/f/data-databases/relational-databases.md) — Stores structured information in tables while enforcing strict data integrity and complex relational constraints.
- [ACID Transactional Cores](https://awesome-repositories.com/f/data-databases/acid-transactional-cores.md) — Guarantees atomicity, consistency, isolation, and durability for all data modifications and concurrent operations.
- [SQL Query Interfaces](https://awesome-repositories.com/f/data-databases/sql-query-interfaces.md) — Manages persistent data using standard query language protocols to ensure reliable storage and consistent access.
- [Data Persistence and Storage](https://awesome-repositories.com/f/data-databases/data-engineering-infrastructure/data-persistence-storage.md) — Organizes information into tables with defined schemas to ensure consistent, long-term storage and retrieval.
- [Data Integrity Constraints](https://awesome-repositories.com/f/data-databases/data-integrity-constraints.md) — Enforces strict logical rules and constraints to maintain accuracy and consistency across related data sets. ([source](https://www.postgresql.org/docs/19/index.html))
- [Multi-Version Concurrency Controls](https://awesome-repositories.com/f/data-databases/multi-version-concurrency-controls.md) — Maintains multiple versions of data rows to allow non-blocking read and write operations.
- [Write-Ahead Logging](https://awesome-repositories.com/f/data-databases/write-ahead-logging.md) — Records data modifications to a sequential log before applying changes to ensure durability during system failures.
- [Custom Data Types](https://awesome-repositories.com/f/data-databases/custom-data-types.md) — Allows definition of custom data types, operators, and indexing methods to support specialized data structures.
- [Object-Relational Mapping](https://awesome-repositories.com/f/data-databases/object-relational-mapping.md) — Supports advanced data types and complex schemas for building highly structured, large-scale applications.
- [Shared Memory Buffers](https://awesome-repositories.com/f/data-databases/shared-memory-buffers.md) — Provides a global memory area for frequently accessed data pages to minimize disk I/O.
- [Structured Data Management](https://awesome-repositories.com/f/data-databases/structured-data-management.md) — Organizes complex information into interconnected sets for reliable, high-performance access. ([source](https://www.postgresql.org/docs/devel/index.html))
- [Structured Data Schemas](https://awesome-repositories.com/f/data-databases/structured-data-schemas.md) — Stores records in defined schemas using specific data types to ensure organized and retrievable information. ([source](https://www.postgresql.org/docs/19/index.html))
- [Query Optimization Engines](https://awesome-repositories.com/f/data-databases/query-optimization-engines.md) — Evaluates multiple execution plans using statistical data to determine the most efficient path for retrieving information.
- [Heap Storage Engines](https://awesome-repositories.com/f/data-databases/heap-storage-engines.md) — Stores data records in unordered collections of pages, relying on separate index structures for efficient retrieval.
- [Process-Per-Connection Architectures](https://awesome-repositories.com/f/data-databases/process-per-connection-architectures.md) — Spawns a dedicated backend process for each client connection to ensure isolation and fault tolerance.