Difference between revisions of "Blockfrost-ryo"
Jump to navigation
Jump to search
↑ https://github.com/blockfrost/blockfrost-backend-ryo/releases/tag/v1.0.0
| Line 23: | Line 23: | ||
** [[CIP68]] | ** [[CIP68]] | ||
** Support for configurable memory settings for [[pm2]] in the [[nix]] service | ** Support for configurable memory settings for [[pm2]] in the [[nix]] service | ||
| + | |||
| + | == Optimization == | ||
| + | [[CREATE INDEX]] IF NOT EXISTS bf_idx_block_hash_encoded ON block USING HASH (encode(hash, 'hex')); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_datum_hash ON datum USING HASH (encode(hash, 'hex')); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_multi_asset_policy ON multi_asset USING HASH (encode(policy, 'hex')); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_multi_asset_policy_name ON multi_asset USING HASH ((encode(policy, 'hex') || encode(name, 'hex'))); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_pool_hash_view ON pool_hash USING HASH (view); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_redeemer_data_hash ON redeemer_data USING HASH (encode(hash, 'hex')); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_scripts_hash ON script USING HASH (encode(hash, 'hex')); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_tx_hash ON tx USING HASH (encode(hash, 'hex')); | ||
| + | CREATE UNIQUE INDEX IF NOT EXISTS bf_u_idx_epoch_stake_epoch_and_id ON epoch_stake (epoch_no, id); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_reference_tx_in_tx_in_id ON reference_tx_in (tx_in_id); | ||
| + | CREATE INDEX IF NOT EXISTS bf_idx_collateral_tx_in_tx_in_id ON collateral_tx_in (tx_in_id); | ||
== Related == | == Related == | ||
Revision as of 07:39, 9 May 2023
(Sep 2022) [1]
docker run --rm \ --name blockfrost-ryo \ -p 3000:3000 \ -e BLOCKFROST_CONFIG_SERVER_LISTEN_ADDRESS=0.0.0.0 \ -v $PWD/config:/app/config \ blockfrost/backend-ryo:latest
System requirements
The system requirements for the basic Blockfrost backend stack (which means blockfrost-backend, cardano-node, cardano-db-sync and postgresql on the same machine) are:
- 64 GB of RAM or more
- 8 CPU cores or more
- 250 GB of disk space or more
- SSD disk with at least 80k IOPS (measured as chunk size)
Optimization
CREATE INDEX IF NOT EXISTS bf_idx_block_hash_encoded ON block USING HASH (encode(hash, 'hex')); CREATE INDEX IF NOT EXISTS bf_idx_datum_hash ON datum USING HASH (encode(hash, 'hex')); CREATE INDEX IF NOT EXISTS bf_idx_multi_asset_policy ON multi_asset USING HASH (encode(policy, 'hex')); CREATE INDEX IF NOT EXISTS bf_idx_multi_asset_policy_name ON multi_asset USING HASH ((encode(policy, 'hex') || encode(name, 'hex'))); CREATE INDEX IF NOT EXISTS bf_idx_pool_hash_view ON pool_hash USING HASH (view); CREATE INDEX IF NOT EXISTS bf_idx_redeemer_data_hash ON redeemer_data USING HASH (encode(hash, 'hex')); CREATE INDEX IF NOT EXISTS bf_idx_scripts_hash ON script USING HASH (encode(hash, 'hex')); CREATE INDEX IF NOT EXISTS bf_idx_tx_hash ON tx USING HASH (encode(hash, 'hex')); CREATE UNIQUE INDEX IF NOT EXISTS bf_u_idx_epoch_stake_epoch_and_id ON epoch_stake (epoch_no, id); CREATE INDEX IF NOT EXISTS bf_idx_reference_tx_in_tx_in_id ON reference_tx_in (tx_in_id); CREATE INDEX IF NOT EXISTS bf_idx_collateral_tx_in_tx_in_id ON collateral_tx_in (tx_in_id);
Related
See also
Advertising:
