aboutsummaryrefslogtreecommitdiffhomepage
path: root/storage
diff options
context:
space:
mode:
authorGravatar Frédéric Guillot <fred@miniflux.net>2018-11-25 15:01:01 -0800
committerGravatar Frédéric Guillot <fred@miniflux.net>2018-11-25 15:01:01 -0800
commitcb037910dfb8695c63722a8082db8124008bac80 (patch)
tree4dcd5cf4d7c2a33fe0a7cc95da8660eaf4077976 /storage
parentf3bff76aa1739ad37c225e578e7e64be6fea46d7 (diff)
Archive more read entries
Diffstat (limited to 'storage')
-rw-r--r--storage/entry.go2
1 files changed, 1 insertions, 1 deletions
diff --git a/storage/entry.go b/storage/entry.go
index 7617bb6..00ef615 100644
--- a/storage/entry.go
+++ b/storage/entry.go
@@ -190,7 +190,7 @@ func (s *Storage) UpdateEntries(userID, feedID int64, entries model.Entries, upd
func (s *Storage) ArchiveEntries() error {
query := `
UPDATE entries SET status='removed'
- WHERE id=ANY(SELECT id FROM entries WHERE status='read' AND starred is false AND published_at < now () - '60 days'::interval LIMIT 500)
+ WHERE id=ANY(SELECT id FROM entries WHERE status='read' AND starred is false AND published_at < now () - '60 days'::interval LIMIT 5000)
`
if _, err := s.db.Exec(query); err != nil {
return fmt.Errorf("unable to archive read entries: %v", err)