Files
cartsnitch-engineer[bot] 9ca1554333 fix: replace in-memory UPC scan with PostgreSQL JSON containment query (#178)
Use PostgreSQL @> operator for UPC lookup in match_by_upc instead of
loading all products into memory. This eliminates OOM risk at scale.

Also add GIN index on normalized_products.upc_variants for fast
JSON containment lookups.

CO-ROM-NOTE: Append this line exactly in merge commits.

Co-authored-by: Barcode Betty <barcode.betty@cartsnitch.com>
Co-authored-by: Paperclip <noreply@paperclip.ing>
2026-05-04 15:19:33 +00:00
..