mirror of
https://github.com/lightninglabs/faraday.git
synced 2026-08-13 12:33:35 +02:00
e852394bdd
Add a PruneChannelEvents query that bounds the channel_events table by both size and age in a single statement: an id-keyset offset enforces a maximum event count and a timestamp filter enforces a retention window, OR-joined so each limit applies independently. The query returns the number of rows deleted so callers can surface pruning activity. Add a standalone timestamp index so the global age-based prune does not scan the full table. The existing composite index leads with channel_id and cannot serve a channel-agnostic timestamp filter. |
||
|---|---|---|
| .. | ||
| 000001_chanevents.down.sql | ||
| 000001_chanevents.up.sql | ||
| 000002_chanevents_ts_idx.down.sql | ||
| 000002_chanevents_ts_idx.up.sql | ||