René's URL Explorer Experiment


Title: fix(db): throttle autovacuum on the largest tables so vacuum WAL bursts stop stalling commits by waleedlatif1 · Pull Request #9087 · simstudioai/sim · GitHub

Open Graph Title: fix(db): throttle autovacuum on the largest tables so vacuum WAL bursts stop stalling commits by waleedlatif1 · Pull Request #9087 · simstudioai/sim

X Title: fix(db): throttle autovacuum on the largest tables so vacuum WAL bursts stop stalling commits by waleedlatif1 · Pull Request #9087 · simstudioai/sim

Description: Summary Vacuuming the largest tables (and their TOAST relations) writes WAL, mostly full-page images, faster than the synchronous standbys can flush it. Until the vacuum ends, every write commit on the primary waits for a standby, so the whole app stalls. Adds migration 0431, which sets a per-table autovacuum_vacuum_cost_delay = 10 / autovacuum_vacuum_cost_limit = 200 on embedding, embedding_search and workflow_execution_logs, for each table and its TOAST relation. That caps how fast those vacuums dirty pages, and so their WAL rate. Trade-off: these three tables leave cross-worker I/O balancing and vacuum more slowly. This reverses 0362's choice for these tables only. Lock analysis: ALTER TABLE ... SET (autovacuum params) only updates the catalog and takes SHARE UPDATE EXCLUSIVE. There is no table rewrite. Reads and writes never wait on it, even while it is queued behind a running vacuum or another holder. A running non-wraparound autovacuum is cancelled by the waiting ALTER and restarts later with the new settings. The migrator's existing 5s lock_timeout plus retry covers the case where the ALTER queues behind a long-running conflicting holder. Type of Change Bug fix Testing New packages/db/large-table-vacuum-throttle-migration.integration.ts runs against real Postgres 17 and checks that: the statement holds only ShareUpdateExclusiveLock, and relfilenode is unchanged (no rewrite); another session can read and write the table while the migration transaction is open; while the ALTER is queued behind a conflicting holder, a writer with a 300ms lock_timeout still inserts; every table and its TOAST relation carry both settings. Fails before this change (the migration file is missing). Also fails if the migration is swapped for an exclusive-lock DDL. check:migrations passes, and drizzle-kit generate reports no schema changes. Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing No new warnings introduced I confirm that I have read and agree to the terms outlined in the Contributor License Agreement (CLA)

Open Graph Description: Summary Vacuuming the largest tables (and their TOAST relations) writes WAL, mostly full-page images, faster than the synchronous standbys can flush it. Until the vacuum ends, every write commit o...

X Description: Summary Vacuuming the largest tables (and their TOAST relations) writes WAL, mostly full-page images, faster than the synchronous standbys can flush it. Until the vacuum ends, every write commit o...

Opengraph URL: https://github.com/simstudioai/sim/pull/9087

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf
route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:c47e1f7a-12f1-771f-19c3-8d269984f0ea
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD316:25245F:DF67B7:1320B2B:6AFB5D24
html-safe-nonce7bb692b6354fc534c9d17a5facf4d0d63d68bca2fa47308cb3a0202f89430b23
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEMzE2OjI1MjQ1RjpERjY3Qjc6MTMyMEIyQjo2QUZCNUQyNCIsInZpc2l0b3JfaWQiOiI4OTQxNjA4NzQwNzg0Mzk3NjA0IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac6e45bdeb8c91eba3eb9cbf8b74e14120aabab6616586b50da0dec8a923b158fe
hovercard-subject-tagpull_request:4879051772
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/simstudioai/sim/pull/9087/files
twitter:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
og:image:altSummary Vacuuming the largest tables (and their TOAST relations) writes WAL, mostly full-page images, faster than the synchronous standbys can flush it. Until the vacuum ends, every write commit o...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noneea33d13c96d0ff66bd8fa906b193d2213536b78cb06b0c50a4632c58b1418f94
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/simstudioai/sim git https://github.com/simstudioai/sim.git
octolytics-dimension-user_id199344406
octolytics-dimension-user_loginsimstudioai
octolytics-dimension-repository_id912559512
octolytics-dimension-repository_nwosimstudioai/sim
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id912559512
octolytics-dimension-repository_network_root_nwosimstudioai/sim
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release59ef97164c52cf59bd10558ddec9c4f482763988
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/9087/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F9087%2Ffiles
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F9087%2Ffiles
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=simstudioai%2Fsim
Reloadhttps://github.com/simstudioai/sim/pull/9087/files
Reloadhttps://github.com/simstudioai/sim/pull/9087/files
Reloadhttps://github.com/simstudioai/sim/pull/9087/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests197 (197)https://github.com/simstudioai/sim/pulls
Actionshttps://github.com/simstudioai/sim/actions
Projectshttps://github.com/simstudioai/sim/projects
Security and qualityhttps://github.com/simstudioai/sim/security
Insightshttps://github.com/simstudioai/sim/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
waleedlatif1https://github.com/waleedlatif1
staginghttps://github.com/simstudioai/sim/tree/staging
fix/vacuum-throttle-large-tableshttps://github.com/simstudioai/sim/tree/fix/vacuum-throttle-large-tables
Conversation 2 https://github.com/simstudioai/sim/pull/9087
Commits 1 https://github.com/simstudioai/sim/pull/9087/commits
Checks 52 https://github.com/simstudioai/sim/pull/9087/checks
Files changed https://github.com/simstudioai/sim/pull/9087/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9087/files
fix(db): throttle autovacuum on the largest tables so vacuum WAL bursts stop stalling commits https://github.com/simstudioai/sim/pull/9087/files#top
Show all changes 1 commit https://github.com/simstudioai/sim/pull/9087/files
7c625b8 fix(db): throttle autovacuum on the largest tables so vacuum WAL burs… waleedlatif1 Oct 15, 2026 https://github.com/simstudioai/sim/pull/9087/commits/7c625b8c0ab90e81422c1d8ab6dc3721332ca4a7
Clear filters https://github.com/simstudioai/sim/pull/9087/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9087/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9087/files
large-table-vacuum-throttle-migration.integration.ts https://github.com/simstudioai/sim/pull/9087/files#diff-92e6779f44d169a88d482d53c1d6bec165d245ca312a02d1b05b34dc04d78e0b
0431_large_table_vacuum_throttle.sql https://github.com/simstudioai/sim/pull/9087/files#diff-852f23cef6a1d84f65b2d9fa301025a3139b0ba4fbb832adacc7cea02e0f709b
0431_snapshot.json https://github.com/simstudioai/sim/pull/9087/files#diff-15968bfa38fc2d8cf6b25a2a383c454e2f590e5ecd5c941d65c7397bab5a0df5
_journal.json https://github.com/simstudioai/sim/pull/9087/files#diff-37150cc65ad16ee6fbc5fa318fc096be7730e16d63eaf863e3df5521b7030649
packages/db/large-table-vacuum-throttle-migration.integration.tshttps://github.com/simstudioai/sim/pull/9087/files#diff-92e6779f44d169a88d482d53c1d6bec165d245ca312a02d1b05b34dc04d78e0b
View file https://github.com/simstudioai/sim/blob/7c625b8c0ab90e81422c1d8ab6dc3721332ca4a7/packages/db/large-table-vacuum-throttle-migration.integration.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9087/{{ revealButtonHref }}
packages/db/migrations/0431_large_table_vacuum_throttle.sqlhttps://github.com/simstudioai/sim/pull/9087/files#diff-852f23cef6a1d84f65b2d9fa301025a3139b0ba4fbb832adacc7cea02e0f709b
View file https://github.com/simstudioai/sim/blob/7c625b8c0ab90e81422c1d8ab6dc3721332ca4a7/packages/db/migrations/0431_large_table_vacuum_throttle.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9087/{{ revealButtonHref }}
Please reload this pagehttps://github.com/simstudioai/sim/pull/9087/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9087/files
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.