Urgent.News

What's breaking now, across thousands of outlets.

More in Tech

max(x) uses the index, max(x) FILTER (where ...) scans the table

Munchable reads a packaged food's label and tells you whether it fits your gut condition. Point the phone at a barcode, get a verdict in about a second.

  • MAX(updatedat) FILTER (WHERE status = 'active') cannot use index efficiently
  • Rewriting query to MAX(updatedat) WHERE status = 'active' improves performance
  • Adjusted TTL to 24 hours for ingredient data caching

More from Thursday 1 October →