René's URL Explorer Experiment


Title: Keep the segment store's lookups by a list of keys from scanning the whole tenant on PostgreSQL by edwinyyyu · Pull Request #1971 · MemMachine/MemMachine · GitHub

Open Graph Title: Keep the segment store's lookups by a list of keys from scanning the whole tenant on PostgreSQL by edwinyyyu · Pull Request #1971 · MemMachine/MemMachine

X Title: Keep the segment store's lookups by a list of keys from scanning the whole tenant on PostgreSQL by edwinyyyu · Pull Request #1971 · MemMachine/MemMachine

Description: Universal memory layer for AI Agents. It provides scalable, extensible, and interoperable memory storage and retrieval to streamline AI agent state management for next-generation autonomous systems. - Keep the segment store's lookups by a list of keys from scanning the whole tenant on PostgreSQL by edwinyyyu · Pull Request #1971 · MemMachine/MemMachine

Open Graph Description: Purpose of the change Fixes #1970. The store reads and deletes a partition's rows for a list of keys with the keys in one IN list. For such a statement PostgreSQL chooses between an index looku...

X Description: Purpose of the change Fixes #1970. The store reads and deletes a partition's rows for a list of keys with the keys in one IN list. For such a statement PostgreSQL chooses between an index l...

Opengraph URL: https://github.com/MemMachine/MemMachine/pull/1971

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/voltron/pull_requests/show/:user_id/:repository/:id/pull_request_layout(.:format)
route-controllervoltron_pull_requests_fragments
route-actionpull_request_layout
fetch-noncev2:dbbec87b-311a-d18d-81ad-7fedf7e6f684
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id8874:4D1C6:2836C79:36D9480:6B004998
html-safe-nonce4ae5513df1e2299f89eeca0c5c05e814e63edaf91043e2b606cbe167b84ea7ef
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4ODc0OjREMUM2OjI4MzZDNzk6MzZEOTQ4MDo2QjAwNDk5OCIsInZpc2l0b3JfaWQiOiIyNTIwMDEyNDAxMzMyNDcyMjE2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac98db857295bdc9cba596426cf51e90cc0c5a8573af2a29d577578841549aae8c
hovercard-subject-tagpull_request:5366367081
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///voltron/pull_requests_fragments/pull_request_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/voltron/pull_requests/show/MemMachine/MemMachine/1971/pull_request_layout
twitter:imagehttps://opengraph.githubassets.com/bb49f183f86a1d3fde277a06b04e6bba037f8bf154faf7e0f898384a538f3af6/MemMachine/MemMachine/pull/1971
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/bb49f183f86a1d3fde277a06b04e6bba037f8bf154faf7e0f898384a538f3af6/MemMachine/MemMachine/pull/1971
og:image:altPurpose of the change Fixes #1970. The store reads and deletes a partition's rows for a list of keys with the keys in one IN list. For such a statement PostgreSQL chooses between an index looku...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameedwinyyyu
hostnamegithub.com
expected-hostnamegithub.com
Nonef9517bf360d46638a1e5e7daee7158842fe5ef43c9000afa0e127564a7c2f39b
turbo-cache-controlno-cache
go-importgithub.com/MemMachine/MemMachine git https://github.com/MemMachine/MemMachine.git
octolytics-dimension-user_id226739620
octolytics-dimension-user_loginMemMachine
octolytics-dimension-repository_id1038686658
octolytics-dimension-repository_nwoMemMachine/MemMachine
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id1038686658
octolytics-dimension-repository_network_root_nwoMemMachine/MemMachine
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releaseb27c5dde30676028abd5c5fc53ce5c9b625f8281
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-namepull-requests

Links:

Skip to contenthttps://github.com/MemMachine/MemMachine/pull/1971#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FMemMachine%2FMemMachine%2Fpull%2F1971
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%2FMemMachine%2FMemMachine%2Fpull%2F1971
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fpull_requests_fragments%2Fpull_request_layout&source=header-repo&source_repo=MemMachine%2FMemMachine
Reloadhttps://github.com/MemMachine/MemMachine/pull/1971
Reloadhttps://github.com/MemMachine/MemMachine/pull/1971
Reloadhttps://github.com/MemMachine/MemMachine/pull/1971
MemMachinehttps://github.com/MemMachine
MemMachinehttps://github.com/MemMachine/MemMachine
Codehttps://github.com/MemMachine/MemMachine
Issues205 (205)https://github.com/MemMachine/MemMachine/issues
Pull requests107 (107)https://github.com/MemMachine/MemMachine/pulls
Discussionshttps://github.com/MemMachine/MemMachine/discussions
Actionshttps://github.com/MemMachine/MemMachine/actions
Projectshttps://github.com/MemMachine/MemMachine/projects
Security and qualityhttps://github.com/MemMachine/MemMachine/security
Insightshttps://github.com/MemMachine/MemMachine/insights
https://github.com/MemMachine/MemMachine
edwinyyyuhttps://github.com/edwinyyyu
MemMachine:mainhttps://github.com/MemMachine/MemMachine/tree/main
edwinyyyu:fix/segment-event-lookup-planhttps://github.com/edwinyyyu/MemMachine/tree/fix/segment-event-lookup-plan
Conversationhttps://github.com/MemMachine/MemMachine/pull/1971
Commits9 (9)https://github.com/MemMachine/MemMachine/pull/1971/commits
Checkshttps://github.com/MemMachine/MemMachine/pull/1971/checks
Files changedhttps://github.com/MemMachine/MemMachine/pull/1971/files
Keep the segment store's lookups by a list of keys from scanning the whole tenant on PostgreSQLhttps://github.com/MemMachine/MemMachine/pull/1971#top
edwinyyyuhttps://github.com/edwinyyyu
MemMachine:mainhttps://github.com/MemMachine/MemMachine/tree/main
edwinyyyu:fix/segment-event-lookup-planhttps://github.com/edwinyyyu/MemMachine/tree/fix/segment-event-lookup-plan
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
Nov 17, 2026https://github.com/MemMachine/MemMachine/pull/1971#issue-6455737802
Please reload this pagehttps://github.com/MemMachine/MemMachine/pull/1971
#1970https://github.com/MemMachine/MemMachine/issues/1970
#1970https://github.com/MemMachine/MemMachine/issues/1970
#1970https://github.com/MemMachine/MemMachine/issues/1970
#1840https://github.com/MemMachine/MemMachine/pull/1840
#1947https://github.com/MemMachine/MemMachine/pull/1947
#1972https://github.com/MemMachine/MemMachine/pull/1972
#1947https://github.com/MemMachine/MemMachine/pull/1947
#1947https://github.com/MemMachine/MemMachine/pull/1947
#1778https://github.com/MemMachine/MemMachine/pull/1778
[Bug]: On PostgreSQL, the segment store's lookups by a list of keys read a large tenant's every row when most tenants are small #1970https://github.com/MemMachine/MemMachine/issues/1970
[partition registry] Replace each store's incarnations with partition UUIDs minted by one registry per partition namespace #1947https://github.com/MemMachine/MemMachine/pull/1947
Run the server's PostgreSQL tests on PostgreSQL 18 #1972https://github.com/MemMachine/MemMachine/pull/1972
Claude Codehttps://claude.com/claude-code
@edwinyyyuhttps://github.com/edwinyyyu
Please reload this pagehttps://github.com/MemMachine/MemMachine/pull/1971
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
Nov 17, 2026 https://github.com/MemMachine/MemMachine/pull/1971#ref-issue-6455722788
[Bug]: On PostgreSQL, the segment store's lookups by a list of keys read a large tenant's every row when most tenants are small #1970 https://github.com/MemMachine/MemMachine/issues/1970
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
performance https://github.com/MemMachine/MemMachine/issues?q=state%3Aopen%20label%3Aperformance
Nov 17, 2026https://github.com/MemMachine/MemMachine/pull/1971#event-36465089747
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
November 18, 2026 21:12https://github.com/MemMachine/MemMachine/pull/1971#event-36579487674
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
Nov 18, 2026https://github.com/MemMachine/MemMachine/pull/1971#event-36579488411
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
Nov 18, 2026https://github.com/MemMachine/MemMachine/pull/1971#event-36582719244
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
November 18, 2026 21:49https://github.com/MemMachine/MemMachine/pull/1971#event-36582844383
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
force-pushedhttps://github.com/MemMachine/MemMachine/compare/01dc72f4814b617eff6aad87d37c50e20c2ed860..be963a479aba971dafce0cfb70476a7292b3e998
01dc72fhttps://github.com/MemMachine/MemMachine/commit/01dc72f4814b617eff6aad87d37c50e20c2ed860
be963a4https://github.com/MemMachine/MemMachine/commit/be963a479aba971dafce0cfb70476a7292b3e998
Compare https://github.com/MemMachine/MemMachine/compare/01dc72f4814b617eff6aad87d37c50e20c2ed860..be963a479aba971dafce0cfb70476a7292b3e998
November 18, 2026 22:13https://github.com/MemMachine/MemMachine/pull/1971#event-36584866209
edwinyyyuhttps://github.com/edwinyyyu
November 19, 2026 15:09https://github.com/MemMachine/MemMachine/pull/1971#commits-pushed-f41d34d
https://github.com/edwinyyyu
https://github.com/claude
Look up each key on its own in the segment store's reads by a list of…https://github.com/MemMachine/MemMachine/pull/1971/commits/f41d34d9f4ac5ab7cf0e7d08f0570cd05db54b93
f41d34dhttps://github.com/MemMachine/MemMachine/pull/1971/commits/f41d34d9f4ac5ab7cf0e7d08f0570cd05db54b93
https://github.com/edwinyyyu
https://github.com/claude
Delete each segment with its own statement, in UUID orderhttps://github.com/MemMachine/MemMachine/pull/1971/commits/44a1fc9180025039fbc51c32d1d9c1fcc223d47f
44a1fc9https://github.com/MemMachine/MemMachine/pull/1971/commits/44a1fc9180025039fbc51c32d1d9c1fcc223d47f
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
force-pushedhttps://github.com/MemMachine/MemMachine/compare/be963a479aba971dafce0cfb70476a7292b3e998..44a1fc9180025039fbc51c32d1d9c1fcc223d47f
be963a4https://github.com/MemMachine/MemMachine/commit/be963a479aba971dafce0cfb70476a7292b3e998
44a1fc9https://github.com/MemMachine/MemMachine/commit/44a1fc9180025039fbc51c32d1d9c1fcc223d47f
Compare https://github.com/MemMachine/MemMachine/compare/be963a479aba971dafce0cfb70476a7292b3e998..44a1fc9180025039fbc51c32d1d9c1fcc223d47f
November 19, 2026 23:10https://github.com/MemMachine/MemMachine/pull/1971#event-36710788900
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
Nov 19, 2026https://github.com/MemMachine/MemMachine/pull/1971#event-36710849916
[Bug]: On PostgreSQL, the segment store's lookups by a list of keys read a large tenant's every row when most tenants are small #1970 https://github.com/MemMachine/MemMachine/issues/1970
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
November 19, 2026 23:15https://github.com/MemMachine/MemMachine/pull/1971#event-36711161489
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
Nov 19, 2026https://github.com/MemMachine/MemMachine/pull/1971#event-36711609027
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
Nov 19, 2026https://github.com/MemMachine/MemMachine/pull/1971#event-36712540063
[Bug]: On PostgreSQL, the segment store's lookups by a list of keys read a large tenant's every row when most tenants are small #1970 https://github.com/MemMachine/MemMachine/issues/1970
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
Nov 19, 2026https://github.com/MemMachine/MemMachine/pull/1971#event-36712572852
[Bug]: On PostgreSQL, the segment store's lookups by a list of keys read a large tenant's every row when most tenants are small #1970 https://github.com/MemMachine/MemMachine/issues/1970
https://github.com/edwinyyyu
edwinyyyuhttps://github.com/edwinyyyu
RonNileshttps://github.com/RonNiles
marvinyu-memvergehttps://github.com/marvinyu-memverge
wanghy73https://github.com/wanghy73
November 19, 2026 23:42https://github.com/MemMachine/MemMachine/pull/1971#event-36713039754
edwinyyyuhttps://github.com/edwinyyyu
November 19, 2026 15:42https://github.com/MemMachine/MemMachine/pull/1971#commits-pushed-91c2907
https://github.com/edwinyyyu
https://github.com/claude
State the key-list lookups by what bounds their cost, with times meas…https://github.com/MemMachine/MemMachine/pull/1971/commits/91c2907c031c44c0da7937517a58238870211388
91c2907https://github.com/MemMachine/MemMachine/pull/1971/commits/91c2907c031c44c0da7937517a58238870211388
https://github.com/edwinyyyu
https://github.com/claude
State that the key-list helper takes each key oncehttps://github.com/MemMachine/MemMachine/pull/1971/commits/d451371b04bf07801a604650c2be4236d3c7f2bc
d451371https://github.com/MemMachine/MemMachine/pull/1971/commits/d451371b04bf07801a604650c2be4236d3c7f2bc
https://github.com/edwinyyyu
https://github.com/claude
State where the planner prices a key's lookup and a scan of its parti…https://github.com/MemMachine/MemMachine/pull/1971/commits/9eb68e6a1f184b3d37f6752174613cec54e5ced5
9eb68e6https://github.com/MemMachine/MemMachine/pull/1971/commits/9eb68e6a1f184b3d37f6752174613cec54e5ced5
https://github.com/edwinyyyu
https://github.com/claude
Say that the deadlock test can deadlock without the UUID orderhttps://github.com/MemMachine/MemMachine/pull/1971/commits/2b3d0dc3bb3784a391c5663a91e3789f28bca656
2b3d0dchttps://github.com/MemMachine/MemMachine/pull/1971/commits/2b3d0dc3bb3784a391c5663a91e3789f28bca656
https://github.com/edwinyyyu
https://github.com/claude
Cut the key-list docstring and the comments beside it to what their c…https://github.com/MemMachine/MemMachine/pull/1971/commits/7b3aeed6429055e6ad999bf6e5ff941de40cb705
7b3aeedhttps://github.com/MemMachine/MemMachine/pull/1971/commits/7b3aeed6429055e6ad999bf6e5ff941de40cb705
https://github.com/edwinyyyu
https://github.com/claude
Make the deadlock test fail when deletions lock in different ordershttps://github.com/MemMachine/MemMachine/pull/1971/commits/518ddcfd9afdf0c0896d90400eff0e60cd4665fc
518ddcfhttps://github.com/MemMachine/MemMachine/pull/1971/commits/518ddcfd9afdf0c0896d90400eff0e60cd4665fc
https://github.com/edwinyyyu
https://github.com/claude
Note which behaviors of delete_segments and the key-list reads no doc…https://github.com/MemMachine/MemMachine/pull/1971/commits/6ab5b53e282e2a742cdd684389db4350dd9395f4
6ab5b53https://github.com/MemMachine/MemMachine/pull/1971/commits/6ab5b53e282e2a742cdd684389db4350dd9395f4
https://github.com/marvinyu-memverge
marvinyu-memvergehttps://github.com/marvinyu-memverge
Nov 20, 2026 https://github.com/MemMachine/MemMachine/pull/1971#pullrequestreview-5986160544
View reviewed changes https://github.com/MemMachine/MemMachine/pull/1971/files/7b3aeed6429055e6ad999bf6e5ff941de40cb705
marvinyu-memvergehttps://github.com/marvinyu-memverge
https://github.com/MemMachine/MemMachine/pull/1971#pullrequestreview-5986160544
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
7b3aeedhttps://github.com/MemMachine/MemMachine/commit/7b3aeed6429055e6ad999bf6e5ff941de40cb705
Please reload this pagehttps://github.com/MemMachine/MemMachine/pull/1971
https://github.co/hiddenchars
https://github.com/MemMachine/MemMachine/pull/{{ revealButtonHref }}
Sign up for freehttps://github.com/join?source=comment-repo
Sign in to commenthttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FMemMachine%2FMemMachine%2Fpull%2F1971
https://github.com/marvinyu-memverge
marvinyu-memverge https://github.com/marvinyu-memverge
https://github.com/MemMachine/MemMachine/pull/1971/files/7b3aeed6429055e6ad999bf6e5ff941de40cb705
https://github.com/RonNiles
RonNiles https://github.com/RonNiles
https://github.com/wanghy73
wanghy73 https://github.com/wanghy73
Please reload this pagehttps://github.com/MemMachine/MemMachine/pull/1971
performance https://github.com/MemMachine/MemMachine/issues?q=state%3Aopen%20label%3Aperformance
[Bug]: On PostgreSQL, the segment store's lookups by a list of keys read a large tenant's every row when most tenants are small https://github.com/MemMachine/MemMachine/issues/1970
Please reload this pagehttps://github.com/MemMachine/MemMachine/pull/1971
https://github.com/edwinyyyu
https://github.com/marvinyu-memverge
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.