/migrate_script

Primary LanguageJavaScript

Migration script from regular table to partition table

This script will do the following steps:

  • Rename the transaction table to transaction_old; message table to message_old
  • Rename all the related indexes of transaction_old and message_old tables with adding _old tag
  • Create new tables with indexes: transaction & message
  • Read from transaction_old and insert into transaction and message tables by batch
  • Drop old function messages_by_address and create a new one
  • For safety reason it does not drop the old tables

How to execute the script

1. Add .env file with DB settings and migration settings:

// example:
PGUSER=UserName
PGHOST=HOST
PGPASSWORD=PASSWORD
PGDATABASE=DB_NAME
PGPORT=DB_PORT

BATCH=5000  // How many rows to be migrated per batch
PARTITION_SIZE=100000 // The number of block heights per partition

2. Verify if the transaction and message schema in utils/create.js are correct

3. Run "npm run prepare-tables", which will

  • Alter the original transaction and message tables to transaction_old & message_old
  • Alter the original indexes with adding _old tag
  • Create new tables transaction and message with new indexes

4. Run "npm run migrate"