]> Sergey Matveev's repositories - public-inbox.git/commit
overidx: {num} column is INTEGER PRIMARY KEY
authorEric Wong <e@80x24.org>
Sat, 5 Dec 2020 22:59:31 +0000 (22:59 +0000)
committerEric Wong <e@80x24.org>
Mon, 7 Dec 2020 07:31:00 +0000 (07:31 +0000)
commita0c41f3d5e9b40bfbb066fa7f0e2e530818ccc0a
treeeb81df04cd4b166167dd3375f599ee428ec512ae
parent4b551c884a648b45ec6b5465efd9fb67f85f0055
overidx: {num} column is INTEGER PRIMARY KEY

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
lib/PublicInbox/OverIdx.pm