diff options
author | Eric Wong <e@80x24.org> | 2020-12-05 22:59:31 +0000 |
---|---|---|
committer | Eric Wong <e@80x24.org> | 2020-12-07 07:31:00 +0000 |
commit | a0c41f3d5e9b40bfbb066fa7f0e2e530818ccc0a (patch) | |
tree | eb81df04cd4b166167dd3375f599ee428ec512ae /lib/PublicInbox/Over.pm | |
parent | 4b551c884a648b45ec6b5465efd9fb67f85f0055 (diff) | |
download | public-inbox-a0c41f3d5e9b40bfbb066fa7f0e2e530818ccc0a.tar.gz |
INTEGER PRIMARY KEY can be an alias for ROWID in SQLite and is already unique, so there's no need for a separate UNIQUE(num) index. With a smallish ~3K, freshly indexed v2 inbox, this results in a ~40K space savings, reducing over.sqlite3 from 1.375M to 1.335M (post-VACUUM). This only affects newly-indexed inboxes; existing DBs will require manual intervention to take advantage of space savings. Link: https://www.sqlite.org/rowidtable.html
Diffstat (limited to 'lib/PublicInbox/Over.pm')
0 files changed, 0 insertions, 0 deletions