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

Christophe Pettus: All Your GUCs in a Row: multixact_member_buffers and multixact_offset_buffers

Planet PostgreSQL2026-10-05 09:000 views

When one long transaction holds row locks on thousands of parents, multixact cache misses can tank insert throughput. (I consult on PostgreSQL through PGX Inc..)

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

My favorites

PreviousCornelia Biacsics: Contributions for week 39 NextChristophe Pettus: All Your GUCs in a Row: min_wal_size

Building an AI Chatbot with Spring Boot and the OpenAI API (2026 Guide)

This is a summary of the full tutorial published on howtostartprogramming.in . TL;DR Aspect Details Tech Stack Java 17,

0dev.to Machine Learning

Automate Telegram Webhook Deployments and Log Purges via Yii2 Console Commands

Deploying a Telegram bot into a production environment requires more than just an HTTP endpoint to accept incoming updat

0dev.to PHP

Parsing WhatsApp chat exports: what real files taught me

A WhatsApp "Export chat" file looks easy: one line per message, a date, a name, some text. I wrote a parser for it, then

0dev.to Programming

A Brighter Flashlight Makes the Release Look Late

A better bug finder does not mean the code got worse. It means you can finally see the bottle caps from 1987, and someon

0dev.to Programming

Building a Minimal Model Context Protocol (MCP) Server in 30 Lines of TypeScript

If you've been experimenting with Anthropic's Claude Code, Claude Desktop, Cursor, or Cline, you've likely seen the Mode

0dev.to TypeScript

AWS contributes a large-transaction binary log optimization to MySQL

When MySQL commits a large transaction carrying gigabytes of changes, writing it to the binary log (binlog) can freeze e

0AWS Database Blog