Skip to content

Optimize HAF tables storage

Work done in this MR: !409 (merged) opens few ways to save a disk space without a performance degradation:

  1. replace physical column: op_type_id in the account_operations table by virtual column defined in a view which extracts this value from encoded operation-id
  2. replace physical column: block_num in the account_operations table by virtual column defined in a view which extracts this value from encoded operation-id
  3. replace physical column: op_type_id in the operations table by virtual column defined in a view which extracts this value from encoded operation-id
  4. replace physical column: block_num in the operations table by virtual column defined in a view which extracts this value from encoded operation-id

The indexes referencing right now removed physical columns should be built by specifying exact expressions as the one used at virtual column definitions. Then it will be possible to still index queries referencing such columns