René's URL Explorer Experiment


Title: fix(file-search): avoid foreground GIN cleanup stalls by icecrasher321 · Pull Request #7995 · simstudioai/sim · GitHub

Open Graph Title: fix(file-search): avoid foreground GIN cleanup stalls by icecrasher321 · Pull Request #7995 · simstudioai/sim

X Title: fix(file-search): avoid foreground GIN cleanup stalls by icecrasher321 · Pull Request #7995 · simstudioai/sim

Description: Summary Avoid foreground GIN cleanup stalls by writing directly to the existing chunk index in 128 KiB batches. File coverage, regex matching, and line numbers stay the same. Disable deferred index writes and drain the existing pending list in a replayable migration, without rebuilding the index or deleting content. Give indexing separate statement and transaction deadlines so slow statements cancel and roll back before PostgreSQL terminates the connection. Type of Change Bug fix Testing 55 integration checks passed on each of PostgreSQL 16 and 17, covering migration replay, pending-list draining, connection survival after cancellation, complete-file publication, regex/line numbers, and dispatch. 152 targeted unit tests; app and database type checks; full lint; all 47 repository audits; migration safety check. Full migration runner on an empty disposable PostgreSQL 17 database, followed by replay; schema generation reports no drift. Synthetic ten-writer runs passed 160 prose batches and 160 dense-text batches on the smaller fixture. On the larger dense fixture with verified cache settings, all 80 batches passed (p95 9.34 s, max 9.54 s on two CPUs), leaving zero pending pages. Direct GIN writes trade bulk throughput for avoiding shared pending-list cleanup. The deliberately cache-constrained dense-text fixture still hits statement timeouts; this change does not remove CPU/I/O capacity limits, and deployment needs insert-latency verification under the real workload. 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 Avoid foreground GIN cleanup stalls by writing directly to the existing chunk index in 128 KiB batches. File coverage, regex matching, and line numbers stay the same. Disable deferred inde...

X Description: Summary Avoid foreground GIN cleanup stalls by writing directly to the existing chunk index in 128 KiB batches. File coverage, regex matching, and line numbers stay the same. Disable deferred inde...

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

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:3c104dc3-ec55-cccb-eba8-bfb85a18496a
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idB838:2C60B8:866A51:BF8D8C:6AFB5090
html-safe-nonce95f73c9d005143891c94910457fc42f0e44ea3880cb0ecd95434a769f12bffef
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCODM4OjJDNjBCODo4NjZBNTE6QkY4RDhDOjZBRkI1MDkwIiwidmlzaXRvcl9pZCI6IjU3MzQzMDU3OTE4MjE0MzUwMjQiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac0281bd95bdbbe2a404ce2df6868876d7c9a0cda55c066f52bc27c80d1f776da7
hovercard-subject-tagpull_request:4574496889
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/7995/files
twitter:imagehttps://avatars.githubusercontent.com/u/17950982?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/17950982?s=400&v=4
og:image:altSummary Avoid foreground GIN cleanup stalls by writing directly to the existing chunk index in 128 KiB batches. File coverage, regex matching, and line numbers stay the same. Disable deferred inde...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None7122bb414b542dba14d71a3f0b9f6fd2abce715b9f5912d082800563e6c806d1
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
releasecbf66c024bb6d10e6955baa7413c54cf13a201bb
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/7995/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F7995%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%2F7995%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/7995/files
Reloadhttps://github.com/simstudioai/sim/pull/7995/files
Reloadhttps://github.com/simstudioai/sim/pull/7995/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
icecrasher321https://github.com/icecrasher321
staginghttps://github.com/simstudioai/sim/tree/staging
codex/fix-file-search-gin-writeshttps://github.com/simstudioai/sim/tree/codex/fix-file-search-gin-writes
Conversation 8 https://github.com/simstudioai/sim/pull/7995
Commits 2 https://github.com/simstudioai/sim/pull/7995/commits
Checks 33 https://github.com/simstudioai/sim/pull/7995/checks
Files changed https://github.com/simstudioai/sim/pull/7995/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7995/files
fix(file-search): avoid foreground GIN cleanup stalls https://github.com/simstudioai/sim/pull/7995/files#top
Show all changes 2 commits https://github.com/simstudioai/sim/pull/7995/files
f0601f6 fix(file-search): avoid foreground GIN cleanup stalls Sep 18, 2026 https://github.com/simstudioai/sim/pull/7995/commits/f0601f6088a7a3d3d2ecc142486fb550651c2db9
757c220 fix(file-search): create chunk GIN index concurrently Sep 19, 2026 https://github.com/simstudioai/sim/pull/7995/commits/757c22057d7738a59045b96ed78e8dafc3034b53
Clear filters https://github.com/simstudioai/sim/pull/7995/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7995/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7995/files
README.md https://github.com/simstudioai/sim/pull/7995/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
chunks.integration.ts https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
constants.ts https://github.com/simstudioai/sim/pull/7995/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
index-state.ts https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
0364_workspace_file_search_direct_gin.sql https://github.com/simstudioai/sim/pull/7995/files#diff-d5f4bd7e1389c99cac34411b6f88746a6151a6ea67e68696a7e0eb48d49725e3
0364_snapshot.json https://github.com/simstudioai/sim/pull/7995/files#diff-66cc9b98a4c8cf0b470e32a78e4e906e2a6e7d56daa947f8eb8476bd719a3821
_journal.json https://github.com/simstudioai/sim/pull/7995/files#diff-37150cc65ad16ee6fbc5fa318fc096be7730e16d63eaf863e3df5521b7030649
schema.ts https://github.com/simstudioai/sim/pull/7995/files#diff-9a959e2ce3cb4c86957bbae021d06eae364f7b0cb18964f5873bab53220af928
apps/sim/lib/workspace-files/search/README.mdhttps://github.com/simstudioai/sim/pull/7995/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
View file https://github.com/simstudioai/sim/blob/757c22057d7738a59045b96ed78e8dafc3034b53/apps/sim/lib/workspace-files/search/README.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7995/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7995/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
https://github.com/simstudioai/sim/pull/7995/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
https://github.com/simstudioai/sim/pull/7995/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
apps/sim/lib/workspace-files/search/chunks.integration.tshttps://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
View file https://github.com/simstudioai/sim/blob/757c22057d7738a59045b96ed78e8dafc3034b53/apps/sim/lib/workspace-files/search/chunks.integration.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7995/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
https://github.com/simstudioai/sim/pull/7995/files#diff-1fad4c2aca071eb8a4b477c529687858aacdd570efedc2dca4180d0c7a18cb78
apps/sim/lib/workspace-files/search/constants.tshttps://github.com/simstudioai/sim/pull/7995/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
View file https://github.com/simstudioai/sim/blob/757c22057d7738a59045b96ed78e8dafc3034b53/apps/sim/lib/workspace-files/search/constants.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7995/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7995/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
https://github.com/simstudioai/sim/pull/7995/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
apps/sim/lib/workspace-files/search/index-state.tshttps://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
View file https://github.com/simstudioai/sim/blob/757c22057d7738a59045b96ed78e8dafc3034b53/apps/sim/lib/workspace-files/search/index-state.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7995/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
https://github.com/simstudioai/sim/pull/7995/files#diff-1fc4408f29d8c373126b9cbfd29d6e8e33a65830fa6f497662476876a0c68066
packages/db/migrations/0364_workspace_file_search_direct_gin.sqlhttps://github.com/simstudioai/sim/pull/7995/files#diff-d5f4bd7e1389c99cac34411b6f88746a6151a6ea67e68696a7e0eb48d49725e3
View file https://github.com/simstudioai/sim/blob/757c22057d7738a59045b96ed78e8dafc3034b53/packages/db/migrations/0364_workspace_file_search_direct_gin.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7995/{{ revealButtonHref }}
Please reload this pagehttps://github.com/simstudioai/sim/pull/7995/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7995/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.