René's URL Explorer Experiment


Title: fix(search): finish retirement and index maintenance on deploy by icecrasher321 · Pull Request #8437 · simstudioai/sim · GitHub

Open Graph Title: fix(search): finish retirement and index maintenance on deploy by icecrasher321 · Pull Request #8437 · simstudioai/sim

X Title: fix(search): finish retirement and index maintenance on deploy by icecrasher321 · Pull Request #8437 · simstudioai/sim

Description: Summary Finish legacy Search retirement in one deployment with 25,000-ID SQL pages, atomic cursor checkpoints, and bounded lock retries. Remove the one-minute/page-count deferral and pacing delay. Follow deletion with a separately journaled concurrent rebuild of the vector projection's HNSW indexes and vacuum/analyze of the affected tables. Resume completed maintenance steps and recover invalid temporary indexes after interrupted rebuilds. Preserve the selected cleanup scope, live Search configuration, and ordinary KB content. The deployment job keeps its existing five-hour timeout; index maintenance may dominate runtime. Type of Change Bug fix Testing All 114 database PostgreSQL/pgvector integration checks passed, including single-invocation completion, cascading deletes, scope isolation, rollback/resume, transient row locks, canceled concurrent index rebuilds, and maintenance checkpoints. All 104 database unit tests, database type-check, lint, API validation, migration safety, docs manifest, and all 52 repository audits passed. Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing (new tests pass the test-audit authoring gate) 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 Finish legacy Search retirement in one deployment with 25,000-ID SQL pages, atomic cursor checkpoints, and bounded lock retries. Remove the one-minute/page-count deferral and pacing delay....

X Description: Summary Finish legacy Search retirement in one deployment with 25,000-ID SQL pages, atomic cursor checkpoints, and bounded lock retries. Remove the one-minute/page-count deferral and pacing delay....

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

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:145950eb-22e6-33b5-4cc3-a6611dd0d784
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD0BC:1EC912:9035E5:CC4E25:6AFB514B
html-safe-nonce48cf163ef9c37b43a513c92ca7aeb1a74612147397ecee76932af1653948f777
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEMEJDOjFFQzkxMjo5MDM1RTU6Q0M0RTI1OjZBRkI1MTRCIiwidmlzaXRvcl9pZCI6IjMyODY2MDAzMjIwNTg1MDY1NzEiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacbac5de380c351451446efb351c2f9fee0bd8f9db15470ef1c435df8e496dddef
hovercard-subject-tagpull_request:4683521938
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/8437/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 Finish legacy Search retirement in one deployment with 25,000-ID SQL pages, atomic cursor checkpoints, and bounded lock retries. Remove the one-minute/page-count deferral and pacing delay....
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/8437/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8437%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%2F8437%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/8437/files
Reloadhttps://github.com/simstudioai/sim/pull/8437/files
Reloadhttps://github.com/simstudioai/sim/pull/8437/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/complete-search-embedding-retirementhttps://github.com/simstudioai/sim/tree/codex/complete-search-embedding-retirement
Conversation 14 https://github.com/simstudioai/sim/pull/8437
Commits 2 https://github.com/simstudioai/sim/pull/8437/commits
Checks 31 https://github.com/simstudioai/sim/pull/8437/checks
Files changed https://github.com/simstudioai/sim/pull/8437/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8437/files
fix(search): finish retirement and index maintenance on deploy https://github.com/simstudioai/sim/pull/8437/files#top
Show all changes 2 commits https://github.com/simstudioai/sim/pull/8437/files
9ff0c3c fix(search): finish retirement and index maintenance on deploy Sep 29, 2026 https://github.com/simstudioai/sim/pull/8437/commits/9ff0c3c0d918c42fa1ff8e4fb78a36ac4e1a3a82
87079ec docs(search): clarify retirement migration session requirement Sep 29, 2026 https://github.com/simstudioai/sim/pull/8437/commits/87079ec819891ad6f9feba345524926bbd8b68b3
Clear filters https://github.com/simstudioai/sim/pull/8437/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8437/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8437/files
0027_retire_search_embeddings.integration.ts https://github.com/simstudioai/sim/pull/8437/files#diff-804f8ab779efcc7c60d89becfb45d2a381b2c5a2f26df28673a0309aa318085e
0027_retire_search_embeddings.ts https://github.com/simstudioai/sim/pull/8437/files#diff-96715460a502d59053405cf39229bf0663576a2d865174d5cbdf25e3d6d01bdc
0028_maintain_search_retirement.ts https://github.com/simstudioai/sim/pull/8437/files#diff-cf4d232e5903f93909f225eddf178051de16d6ae3b469abe886ecd8e230dc01d
index.ts https://github.com/simstudioai/sim/pull/8437/files#diff-4c8058a0b924ce061c5ce010c1308148ea03720952dda10d03cee092b61adbd6
search-embedding-retirement.md https://github.com/simstudioai/sim/pull/8437/files#diff-35b3bda34ec67653fcd46b1b2f93525a0282f6bb7407a7c2533d97ae4a7cc689
packages/db/script-migrations/0027_retire_search_embeddings.integration.tshttps://github.com/simstudioai/sim/pull/8437/files#diff-804f8ab779efcc7c60d89becfb45d2a381b2c5a2f26df28673a0309aa318085e
View file https://github.com/simstudioai/sim/blob/87079ec819891ad6f9feba345524926bbd8b68b3/packages/db/script-migrations/0027_retire_search_embeddings.integration.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8437/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8437/files#diff-804f8ab779efcc7c60d89becfb45d2a381b2c5a2f26df28673a0309aa318085e
https://github.com/simstudioai/sim/pull/8437/files#diff-804f8ab779efcc7c60d89becfb45d2a381b2c5a2f26df28673a0309aa318085e
https://github.com/simstudioai/sim/pull/8437/files#diff-804f8ab779efcc7c60d89becfb45d2a381b2c5a2f26df28673a0309aa318085e
https://github.com/simstudioai/sim/pull/8437/files#diff-804f8ab779efcc7c60d89becfb45d2a381b2c5a2f26df28673a0309aa318085e
https://github.com/simstudioai/sim/pull/8437/files#diff-804f8ab779efcc7c60d89becfb45d2a381b2c5a2f26df28673a0309aa318085e
Please reload this pagehttps://github.com/simstudioai/sim/pull/8437/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8437/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.