Bitcoin full node and query server

Feb 18, 2025

View in context in the libbitcoin Slack #general mirror.

evoskuil03:05
The theory is that the combined table is not required for the expansive confirmation query, only the point table (just point hashes) and the spend index (7 byte "short" points) are required. So this removes 16 bytes per row, from a table with 2.6 billion rows. The table gets hit hard during confirmation, and this cuts it from around 126GiB to around 84GiB.