# Postgres patterns

## Overview
This document discusses various patterns used in PostgreSQL databases. The patterns outlined present solutions for common scenarios encountered in database management and optimization.

## Common Patterns
### Relational Records
This pattern deals with the organization and retrieval of relational data.

### Transactional Workflows
Describes how to manage workflows that require transactional integrity.

### JSON Document Metadata
Explains how to store and retrieve metadata for JSON documents in a relational database.

### Multi-tenant Relational Data
Details strategies for efficiently handling data for multiple tenants in a single database schema.

### Text Search Over Records
Discusses methods for implementing search functionalities across text fields in relational records.

### Durable Job State
Covers approaches for tracking the state of long-running jobs within the database.