8000 [pull] main from miniflux:main by pull[bot] · Pull Request #262 · abcdlsj/miniflux · GitHub
[go: up one dir, main page]

Skip to content
Merged
8000
Changes from all commits
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
16 changes: 16 additions & 0 deletions internal/database/migrations.go
Original file line number Diff line number Diff line change
Expand Up @@ -1387,4 +1387,20 @@ var migrations = [...]func(tx *sql.Tx) error{
_, err = tx.Exec(sql)
return err
},
func(tx *sql.Tx) (err error) {
// There is no need to keep an index on the content of deleted entries.
_, err = tx.Exec(`DROP INDEX document_vectors_idx;`)
if err != nil {
return err
}

sql := `
CREATE INDEX document_vectors_idx
ON entries
USING gin(document_vectors)
WHERE status != 'removed';
`
_, err = tx.Exec(sql)
return err
},
}
Loading
0