中文 English Français Русский Español العربية

Christophe Pettus: All Your GUCs in a Row: recovery_init_sync_method

Planet PostgreSQL2026-10-20 09:000 views

After a crash, PostgreSQL syncs every file in your data directory before replaying any WAL—and on large clusters, this can consume minutes. (I consult on PostgreSQL through PGX Inc..)

Source：https://postgr.es/p/9zb

My favorites

PreviousChristophe Pettus: All Your GUCs in a Row: recovery_min_apply_delay NextTurning coffee waste into 3D-printed architectural forms

Postgres LISTEN/NOTIFY vs Redis Pub/Sub: Latency, Write Cost and Failure Cases, Tested

Cross-posted from my blog. The original, with any updates, lives on fabwaseem.com . If you already run Postgres, you can

0dev.to Node

LlamaIndex Workflows vs LangGraph: Event-Driven Architecture and Async State Overhead Showdown

LlamaIndex Workflows and LangGraph represent the two dominant paradigms for orchestrating complex agentic swarms: pure e

0dev.to Programming

Rider and Databases: Lesser-Known IDE Features That Save Time

Most developers work with databases through dedicated tools: some prefer SQL Server Management Studio (SSMS), others go

0dev.to Database

KivaDB v2: What's Coming and How You Can Contribute

We're excited to announce that development for KivaDB v2 is officially underway! In this post, we'll share what we're pl

0dev.to Database

Your LLM cost log says $0.00. The invoice says $1,320.

You log what each LLM call costs, right next to the request, in a DECIMAL(10,2) column like every other amount of money

0dev.to Database

SQLite in Production: A Practical Setup with Litestream Backups

SQLite often gets dismissed as a toy database, which surprises the many useful applications quietly running on it. For a

0dev.to Database

Christophe Pettus: All Your GUCs in a Row: recovery_init_sync_method

Related posts

Postgres LISTEN/NOTIFY vs Redis Pub/Sub: Latency, Write Cost and Failure Cases, Tested

LlamaIndex Workflows vs LangGraph: Event-Driven Architecture and Async State Overhead Showdown

Rider and Databases: Lesser-Known IDE Features That Save Time

KivaDB v2: What's Coming and How You Can Contribute

Your LLM cost log says $0.00. The invoice says $1,320.

SQLite in Production: A Practical Setup with Litestream Backups