Skip to content

v0.3.1
Compare
Choose a tag to compare
@i-norden i-norden released this 20 Dec 19:08
v0.3.1
762bc36
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

New database schema, this is breaking upgrade so we are moving to a new minor version.

The primary objective of this upgrade is to move from a serial int based primary/foreign key scheme to a deterministic natural key scheme, this helps facilitate horizontal scaling by avoiding serial key conflicts when merging separate databases.

We also introduce sets of migrations split into pre- and post- historical batch processing units. The pre- set forgoes all FK and unique constraints, indexes, and sets the tables as UNLOGGED. The post- set adds these constraints and indexes and sets the tables as LOGGED. This is to improve performance of historical batch processing.

There are also some other smalls adjustments to the schema: switching some BIGINT types to NUMERIC to avoid overflow, adding some additional rows that will be useful for searches (e.g. header_cids.coinbase) and removing some that are not particularly useful (e.g. header_cids.base_fee).

Changelog: release-v0.2.1...release-v0.3.1

Assets 2
Loading