$ show NDXDeveloper/formation-postgresql-18
This repository is a comprehensive French-language training course for PostgreSQL 18, structured as 22 progressive chapters and 7 reference annexes. It serves as educational material covering PostgreSQL fundamentals, SQL querying, advanced features, administration, performance tuning, extensions, and modern architectures. The content combines theoretical explanations with practical examples, best practices, and version-specific features (like asynchronous I/O, UUIDv7, and native OAuth). While not containing executable code or data pipelines, it provides reusable reference materials such as SQL query templates, shell scripts for backup/monitoring, configuration guides, and checklists that can be adapted across projects. The repository is actively maintained with recent updates and demonstrates low technical drift due to its focus on enduring database principles alongside version-specific annotations.
The LLM identified 5 files worth highlighting for reuse:
Collection of ready-to-use SQL queries categorized by administration, monitoring, and analysis. Includes parameterized templates for checking locks, replication lag, bloat, and performance metrics. Designed for direct adaptation to different schemas with minimal modification.
Shell scripts for automated backups (logical/physical), system monitoring, and maintenance tasks. Features parameterized configurations, error handling, and logging best practices. Can be deployed across environments with minor adjustments to connection parameters and retention policies.
Pre-configured postgresql.conf samples for different workload types (OLTP, OLAP, mixed, development). Includes annotated explanations of key parameters like shared_buffers, work_mem, and vacuum settings. Provides starting points for performance tuning that require only workload-specific adjustments.
Structured audit checklists covering configuration, indexing, query performance, and schema design. Each item includes verification steps, common issues, and remediation guidance. Enables systematic performance reviews without missing critical areas.
Concise reference of PostgreSQL 18 features with adoption recommendations and compatibility notes. Organized by category (performance, security, replication, etc.) with clear indicators of backward compatibility. Serves as a quick-reference guide for upgrade planning.