Skip to content
3 linesCodeBlameRaw
1-- Deliveries older than a fortnight are forgotten each hour, oldest first:
2-- by time, a range rather than a scan of every delivery.
3CREATE INDEX IF NOT EXISTS deliveries_by_time ON deliveries (created_at);