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

Chris van Eijk: could not serialize access due to concurrent update

Planet PostgreSQL2026-10-16 08:000 views

PostgreSQL error 40001 'could not serialize access due to concurrent update', measured on 17: when it fires, why SKIP LOCKED does not avoid it, and the retry.

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

My favorites

PreviousChris van Eijk: idle in transaction in PostgreSQL: what it holds NextShow HN: What if Instinct and GrokBot had a baby?

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

The Scariest Part of "Skynet Mode" Is Your Own Unauthenticated Endpoint

Somebody finally caught an attack agent with its pants down, and the interesting part isn't the name. Symantec researche

0dev.to Security

pgvector for Beginners: Add Semantic Search to PostgreSQL

You already have PostgreSQL, backups, and a team that knows how to operate them. Then a new feature asks for semantic se

0dev.to

Chris van Eijk: could not serialize access due to concurrent update

Related posts

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

The Scariest Part of "Skynet Mode" Is Your Own Unauthenticated Endpoint

pgvector for Beginners: Add Semantic Search to PostgreSQL