Urgent.News

What's breaking now, across thousands of outlets.

Tech

Beyond Disk and WAL: What Limits PostgreSQL Scaling?

The earlier tests improved read I/O and removed standby acknowledgment waiting, but the primary still waited for local WAL synchronization. Separate, later durable-regime traces located substantial delay in guest-OS write admission. This post returns to the diagnostic where I stopped waiting for commit durability to see what remained. I used session-level synchronous_commit=off for the same…

The investigation into PostgreSQL scaling reveals that while earlier tests improved read I/O and removed standby acknowledgment waiting, the primary node still experienced delays due to local WAL synchronization. This post revisits the diagnostic and examines the remaining bottlenecks. By setting session-level synchronous_commit=off, a successful commit response can be achieved before WAL is durable, potentially leading to data loss in the event of a crash.

However, this method was used for diagnostic purposes in a controlled lab environment, deviating from the initial comparison with HorizonDB's high-availability features.

The study maintains both streaming replicas and enables WAL, fsync, and full_page_writes. Automatic Patroni failover is also paused during the diagnostic. To gather data, a Pgtcl connection with an override setting of synchronous_commit=off was used to execute a SHOW synchronous_commit query. The test revealed that 93.92% of sampled active-client observations were impacted by LWLock:BufferContent, indicating a wait for a lightweight lock protecting cached relation pages.

This suggests that the primary bottleneck lies in managing access to in-memory pages within the PostgreSQL server.

Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.

Read the original at dev.to →

More in Tech

Dogtag PKI: 22 title matches and the certificate-authority boundary

Dogtag PKI: 22 title matches and the certificate-authority boundary Dogtag Certificate System is an open-source public-key infrastructure used to validate certificate requests, issue certificates…

  • Dogtag PKI validates certificate requests and issues certificates
  • Certificate authority provides enrollment portal and token management
  • Secure system requires restricted admin access and monitored certificate services

Vibe directing: letting a sentence edit a video timeline without trampling your hand edits

Disclosure up front: we build ClickPop, an AI video studio, and this post is about a design problem we hit while building its editor.

  • Vibe directing allows editing videos by specifying changes in text, not altering rendered shots.
  • Timeline is the source of truth; agent communicates in editor actions, not its own language.
  • Preserve hand-edited layers; agent reads diffs to plan edits around manual changes.

Healthtech Autonomous Agent Spend Caps With 3 Auditable Budget Gates

Enforce an autonomous agent's spending ceiling at the account, outside the loop's control, and estimate cost before each expensive step.

  • Three auditable budget gates implemented for healthtech autonomous agent
  • Account enforcement sets spending ceiling, pre-call admission estimates costs
  • Invoice reconciliation explains charges, patient data separate from invoice total

The €4.7 Million Font Problem

The €4.7 Million Font Problem What unpaid trial fonts on live websites are worth, how we priced them, and why the real number is higher Abstract.

  • €4.7 million in unpaid font licences estimated to cost type design industry
  • Top 10 foundries account for 73% of unpaid licensing value
  • Only 88 cases unable to be priced, indicating widespread issue

More from Tuesday 17 November →