| react-profiling | 0 |
| react-import-map | react,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-controller | voltron_pull_requests_fragments |
| route-action | pull_request_layout |
| fetch-nonce | v2:dbbec87b-311a-d18d-81ad-7fedf7e6f684 |
| current-catalog-service-hash | ae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b |
| request-id | 8874:4D1C6:2836C79:36D9480:6B004998 |
| html-safe-nonce | 4ae5513df1e2299f89eeca0c5c05e814e63edaf91043e2b606cbe167b84ea7ef |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4ODc0OjREMUM2OjI4MzZDNzk6MzZEOTQ4MDo2QjAwNDk5OCIsInZpc2l0b3JfaWQiOiIyNTIwMDEyNDAxMzMyNDcyMjE2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 98db857295bdc9cba596426cf51e90cc0c5a8573af2a29d577578841549aae8c |
| hovercard-subject-tag | pull_request:5366367081 |
| github-keyboard-shortcuts | repository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | ///voltron/pull_requests_fragments/pull_request_layout |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/voltron/pull_requests/show/MemMachine/MemMachine/1971/pull_request_layout |
| twitter:image | https://opengraph.githubassets.com/bb49f183f86a1d3fde277a06b04e6bba037f8bf154faf7e0f898384a538f3af6/MemMachine/MemMachine/pull/1971 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/bb49f183f86a1d3fde277a06b04e6bba037f8bf154faf7e0f898384a538f3af6/MemMachine/MemMachine/pull/1971 |
| og:image:alt | 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... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | edwinyyyu |
| hostname | github.com |
| expected-hostname | github.com |
| None | f9517bf360d46638a1e5e7daee7158842fe5ef43c9000afa0e127564a7c2f39b |
| turbo-cache-control | no-cache |
| go-import | github.com/MemMachine/MemMachine git https://github.com/MemMachine/MemMachine.git |
| octolytics-dimension-user_id | 226739620 |
| octolytics-dimension-user_login | MemMachine |
| octolytics-dimension-repository_id | 1038686658 |
| octolytics-dimension-repository_nwo | MemMachine/MemMachine |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 1038686658 |
| octolytics-dimension-repository_network_root_nwo | MemMachine/MemMachine |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | b27c5dde30676028abd5c5fc53ce5c9b625f8281 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | pull-requests |
| Skip to content | https://github.com/MemMachine/MemMachine/pull/1971#start-of-content |
| https://github.com/ |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FMemMachine%2FMemMachine%2Fpull%2F1971 |
| GitHubRepository hosting, code review, and collaboration | https://github.com/platform |
| CopilotAI coding agent for tasks, projects, and automated work | https://github.com/features/copilot |
| ActionsCI/CD and automation | https://github.com/features/actions |
| Code QualityQuality analysis, fixes, and enforcement | https://github.com/features/code-quality |
| CodespacesCloud development environments | https://github.com/features/codespaces |
| Code SecurityVulnerability detection and remediation | https://github.com/security/advanced-security/code-security |
| Secret ProtectionSecret scanning and leak prevention | https://github.com/security/advanced-security/secret-protection |
| All Features | https://github.com/features |
| Documentation | https://docs.github.com/en |
| Training | https://learn.github.com/skills |
| Certifications | https://learn.github.com/credentials |
| Build with Copilot | https://github.com/features/ai |
| Customize Copilot | https://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview |
| Integrations | https://github.com/marketplace |
| Trending repos | https://github.com/trending |
| GitHub Sponsors | https://github.com/open-source/sponsors |
| Developer articles | https://github.com/resources/articles |
| ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place. | https://github.blog/changelog/ |
| Enterprises | https://github.com/enterprise |
| Team | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| Healthcare | https://github.com/solutions/industry/healthcare |
| Financial services | https://github.com/solutions/industry/financial-services |
| Manufacturing | https://github.com/solutions/industry/manufacturing |
| Government | https://github.com/solutions/industry/government |
| See all industries | https://github.com/solutions/industry |
| Why GitHub | https://github.com/why-github |
| Customer Stories | https://github.com/customer-stories |
| Business insights | https://github.com/solutions/executive-insights |
| Trust Center | https://github.com/trust-center |
| GitHub Advanced SecurityEnterprise-grade code security | https://github.com/security/advanced-security |
| Copilot for businessEnterprise-grade AI features | https://github.com/features/copilot/copilot-business |
| Premium SupportEnterprise-grade 24/7 support | https://github.com/enterprise/premium-support |
| Documentation | https://docs.github.com/en |
| Resource center | https://github.com/resources |
| Blog | https://github.blog/ |
| Events & webinars | https://github.com/resources/events |
| Community Forum | https://github.com/orgs/community/discussions |
| Customer Stories | https://github.com/customer-stories |
| Integrations | https://github.com/marketplace |
| Customer support | https://help.github.com/ |
| Training | https://learn.github.com/skills |
| GitHub Status | https://www.githubstatus.com/ |
| About | https://github.com/about |
| Partners | https://github.com/partners |
| Changelog | https://github.blog/changelog/ |
| GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub. | https://githubuniverse.com/ |
| Pricing | https://github.com/pricing |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FMemMachine%2FMemMachine%2Fpull%2F1971 |
| Sign up | https://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 |
| Reload | https://github.com/MemMachine/MemMachine/pull/1971 |
| Reload | https://github.com/MemMachine/MemMachine/pull/1971 |
| Reload | https://github.com/MemMachine/MemMachine/pull/1971 |
| MemMachine | https://github.com/MemMachine |
| MemMachine | https://github.com/MemMachine/MemMachine |
| Code | https://github.com/MemMachine/MemMachine |
| Issues205 (205) | https://github.com/MemMachine/MemMachine/issues |
| Pull requests107 (107) | https://github.com/MemMachine/MemMachine/pulls |
| Discussions | https://github.com/MemMachine/MemMachine/discussions |
| Actions | https://github.com/MemMachine/MemMachine/actions |
| Projects | https://github.com/MemMachine/MemMachine/projects |
| Security and quality | https://github.com/MemMachine/MemMachine/security |
| Insights | https://github.com/MemMachine/MemMachine/insights |
| https://github.com/MemMachine/MemMachine |
| edwinyyyu | https://github.com/edwinyyyu |
| MemMachine:main | https://github.com/MemMachine/MemMachine/tree/main |
| edwinyyyu:fix/segment-event-lookup-plan | https://github.com/edwinyyyu/MemMachine/tree/fix/segment-event-lookup-plan |
| Conversation | https://github.com/MemMachine/MemMachine/pull/1971 |
| Commits9 (9) | https://github.com/MemMachine/MemMachine/pull/1971/commits |
| Checks | https://github.com/MemMachine/MemMachine/pull/1971/checks |
| Files changed | https://github.com/MemMachine/MemMachine/pull/1971/files |
| Keep the segment store's lookups by a list of keys from scanning the whole tenant on PostgreSQL | https://github.com/MemMachine/MemMachine/pull/1971#top |
| edwinyyyu | https://github.com/edwinyyyu |
| MemMachine:main | https://github.com/MemMachine/MemMachine/tree/main |
| edwinyyyu:fix/segment-event-lookup-plan | https://github.com/edwinyyyu/MemMachine/tree/fix/segment-event-lookup-plan |
|
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| Nov 17, 2026 | https://github.com/MemMachine/MemMachine/pull/1971#issue-6455737802 |
| Please reload this page | https://github.com/MemMachine/MemMachine/pull/1971 |
| #1970 | https://github.com/MemMachine/MemMachine/issues/1970 |
| #1970 | https://github.com/MemMachine/MemMachine/issues/1970 |
| #1970 | https://github.com/MemMachine/MemMachine/issues/1970 |
| #1840 | https://github.com/MemMachine/MemMachine/pull/1840 |
| #1947 | https://github.com/MemMachine/MemMachine/pull/1947 |
| #1972 | https://github.com/MemMachine/MemMachine/pull/1972 |
| #1947 | https://github.com/MemMachine/MemMachine/pull/1947 |
| #1947 | https://github.com/MemMachine/MemMachine/pull/1947 |
| #1778 | https://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 #1970 | https://github.com/MemMachine/MemMachine/issues/1970 |
| [partition registry] Replace each store's incarnations with partition UUIDs minted by one registry per partition namespace #1947 | https://github.com/MemMachine/MemMachine/pull/1947 |
| Run the server's PostgreSQL tests on PostgreSQL 18 #1972 | https://github.com/MemMachine/MemMachine/pull/1972 |
| Claude Code | https://claude.com/claude-code |
| @edwinyyyu | https://github.com/edwinyyyu |
| Please reload this page | https://github.com/MemMachine/MemMachine/pull/1971 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://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 |
| edwinyyyu | https://github.com/edwinyyyu |
|
performance
| https://github.com/MemMachine/MemMachine/issues?q=state%3Aopen%20label%3Aperformance |
| Nov 17, 2026 | https://github.com/MemMachine/MemMachine/pull/1971#event-36465089747 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| November 18, 2026 21:12 | https://github.com/MemMachine/MemMachine/pull/1971#event-36579487674 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| Nov 18, 2026 | https://github.com/MemMachine/MemMachine/pull/1971#event-36579488411 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| Nov 18, 2026 | https://github.com/MemMachine/MemMachine/pull/1971#event-36582719244 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| November 18, 2026 21:49 | https://github.com/MemMachine/MemMachine/pull/1971#event-36582844383 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| force-pushed | https://github.com/MemMachine/MemMachine/compare/01dc72f4814b617eff6aad87d37c50e20c2ed860..be963a479aba971dafce0cfb70476a7292b3e998 |
| 01dc72f | https://github.com/MemMachine/MemMachine/commit/01dc72f4814b617eff6aad87d37c50e20c2ed860 |
| be963a4 | https://github.com/MemMachine/MemMachine/commit/be963a479aba971dafce0cfb70476a7292b3e998 |
|
Compare
| https://github.com/MemMachine/MemMachine/compare/01dc72f4814b617eff6aad87d37c50e20c2ed860..be963a479aba971dafce0cfb70476a7292b3e998 |
| November 18, 2026 22:13 | https://github.com/MemMachine/MemMachine/pull/1971#event-36584866209 |
| edwinyyyu | https://github.com/edwinyyyu |
| November 19, 2026 15:09 | https://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 |
| f41d34d | https://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 order | https://github.com/MemMachine/MemMachine/pull/1971/commits/44a1fc9180025039fbc51c32d1d9c1fcc223d47f |
| 44a1fc9 | https://github.com/MemMachine/MemMachine/pull/1971/commits/44a1fc9180025039fbc51c32d1d9c1fcc223d47f |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| force-pushed | https://github.com/MemMachine/MemMachine/compare/be963a479aba971dafce0cfb70476a7292b3e998..44a1fc9180025039fbc51c32d1d9c1fcc223d47f |
| be963a4 | https://github.com/MemMachine/MemMachine/commit/be963a479aba971dafce0cfb70476a7292b3e998 |
| 44a1fc9 | https://github.com/MemMachine/MemMachine/commit/44a1fc9180025039fbc51c32d1d9c1fcc223d47f |
|
Compare
| https://github.com/MemMachine/MemMachine/compare/be963a479aba971dafce0cfb70476a7292b3e998..44a1fc9180025039fbc51c32d1d9c1fcc223d47f |
| November 19, 2026 23:10 | https://github.com/MemMachine/MemMachine/pull/1971#event-36710788900 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| Nov 19, 2026 | https://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 |
| edwinyyyu | https://github.com/edwinyyyu |
| November 19, 2026 23:15 | https://github.com/MemMachine/MemMachine/pull/1971#event-36711161489 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| Nov 19, 2026 | https://github.com/MemMachine/MemMachine/pull/1971#event-36711609027 |
| https://github.com/edwinyyyu |
| edwinyyyu | https://github.com/edwinyyyu |
| Nov 19, 2026 | https://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 |
| edwinyyyu | https://github.com/edwinyyyu |
| Nov 19, 2026 | https://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 |
| edwinyyyu | https://github.com/edwinyyyu |
| RonNiles | https://github.com/RonNiles |
| marvinyu-memverge | https://github.com/marvinyu-memverge |
| wanghy73 | https://github.com/wanghy73 |
| November 19, 2026 23:42 | https://github.com/MemMachine/MemMachine/pull/1971#event-36713039754 |
| edwinyyyu | https://github.com/edwinyyyu |
| November 19, 2026 15:42 | https://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 |
| 91c2907 | https://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 once | https://github.com/MemMachine/MemMachine/pull/1971/commits/d451371b04bf07801a604650c2be4236d3c7f2bc |
| d451371 | https://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 |
| 9eb68e6 | https://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 order | https://github.com/MemMachine/MemMachine/pull/1971/commits/2b3d0dc3bb3784a391c5663a91e3789f28bca656 |
| 2b3d0dc | https://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 |
| 7b3aeed | https://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 orders | https://github.com/MemMachine/MemMachine/pull/1971/commits/518ddcfd9afdf0c0896d90400eff0e60cd4665fc |
| 518ddcf | https://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 |
| 6ab5b53 | https://github.com/MemMachine/MemMachine/pull/1971/commits/6ab5b53e282e2a742cdd684389db4350dd9395f4 |
| https://github.com/marvinyu-memverge |
| marvinyu-memverge | https://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-memverge | https://github.com/marvinyu-memverge |
| https://github.com/MemMachine/MemMachine/pull/1971#pullrequestreview-5986160544 |
| Learn more | https://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment |
| 7b3aeed | https://github.com/MemMachine/MemMachine/commit/7b3aeed6429055e6ad999bf6e5ff941de40cb705 |
| Please reload this page | https://github.com/MemMachine/MemMachine/pull/1971 |
| https://github.co/hiddenchars |
| https://github.com/MemMachine/MemMachine/pull/{{ revealButtonHref }} |
| Sign up for free | https://github.com/join?source=comment-repo |
| Sign in to comment | https://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 page | https://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 page | https://github.com/MemMachine/MemMachine/pull/1971 |
|
| https://github.com/edwinyyyu |
|
| https://github.com/marvinyu-memverge |
|
| https://github.com |
| Terms | https://docs.github.com/site-policy/github-terms/github-terms-of-service |
| Privacy | https://docs.github.com/site-policy/privacy-policies/github-privacy-statement |
| Security | https://github.com/security |
| Status | https://www.githubstatus.com/ |
| Community | https://github.community/ |
| Docs | https://docs.github.com/ |
| Contact | https://support.github.com?tags=dotcom-footer |