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

Skip to content

[pull] main from miniflux:main - #367

Merged
pull[bot] merged 1 commit into
suhaoGe:mainfrom
miniflux:main
Aug 24, 2026
Merged

pull[bot] merged 1 commit into
suhaoGe:mainfrom
miniflux:main

Conversation

@pull
@pull pull Bot commented Aug 24, 2026 •
Copy link
Copy Markdown

See Commits and Changes for more details.


Created by pull[bot] (v2.0.0-alpha.4)

Can you help keep this open source service alive? 💖 Please sponsor : )

The enclosures_user_entry_url_unique_idx expression index stored the URL
digest as encode(sha256(url::bytea), 'hex'), a 64-byte hex text encoding
of a 32-byte value. Index the raw sha256(url::bytea) bytea instead to
roughly halve the index on disk, and update the matching ON CONFLICT
clause in createEnclosure so its inference still resolves to the index.

On 150k enclosures the index shrank from 27 MB to 11 MB (~59%).
@pull pull Bot locked and limited conversation to collaborators Aug 24, 2026
@pull pull Bot added the ⤵️ pull label Aug 24, 2026
@pull
pull Bot merged commit a84533d into suhaoGe:main Aug 24, 2026
1 check passed
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant

0