forked from cartsnitch/cartsnitch
9ca1554333
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>