Skip to content
Update benchmarks authored by Philippe Wang's avatar Philippe Wang
......@@ -28,6 +28,13 @@
### Host=amd.local with some PG configuration tweaking
the following two reports show that PG tweaks made indexing a little faster or the conversion a little faster, but not both at once
```
0.03user 0.02system 24:53.80elapsed 0%CPU (0avgtext+0avgdata 12200maxresident)k 10584inputs+0outputs (92major+3094minor)pagefaults 0swaps real 24m53.803s user 0m0.294s sys 0m0.084s Indexing started on Sun Sep 19 10:21:34 AM PDT 2021 - ended on Sun Sep 19 12:00:22 PM PDT 2021 0.02user 0.00system 0:00.80elapsed 2%CPU (0avgtext+0avgdata 12532maxresident)k 9520inputs+0outputs (95major+3081minor)pagefaults 0swaps ##################################### Database: HOST=localhost DB=v960rc1 PORT=5432 PG_USER=phil DB_USER=phil PSQL_OPTIONS= PSQL=time psql -h localhost -p 5432 -U phil v960rc1 -a Tezos node: TEZOS_NODE=http://127.0.0.1:8732 TEZOS_NODE2=http://localhost:8733 TEZOS_NODE3=http://localhost:8734 TEZOS_NODE4=http://localhost:8735 TEZOS_NODE5=http://localhost:8736 TEZOS_NODE6=http://localhost:8737 TEZOS_NODE7=http://localhost:8738 TEZOS_NODE8=http://localhost:8733 TEZOS_NODE9=http://localhost:8734 TEZOS_NODEA=http://localhost:8735 Tezos-indexer: TI=. LOGS_DIR=/tmp/L BLOCK_CACHE_DIR=/home/phil/blocks/ INDEXER_DATAKINDS=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support INDEXER_RUN=--use-disk-cache --debug --verbosity=1 --verbose INDEXER_OTHER_OPTIONS= gsize=2000 top=1680000 PROCESSES=48 LOGS_DIR=/tmp/L BLOCK_CACHE_DIR=/home/phil/blocks/ LOGS=/tmp/L/indexer-segment-2000-localhost-v960rc1 INDEXER_OPTIONS1=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8732 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONS2=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8733 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONS3=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8734 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONS4=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8735 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONS5=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8736 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONS6=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8737 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONS7=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8738 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONS8=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8733 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONS9=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8734 --block-cache-directory=/home/phil/blocks/ INDEXER_OPTIONSA=--no-contract-balances --no-snapshot --do-not-get-missing-scripts --no-watch --tokens-support --use-disk-cache --debug --verbosity=1 --verbose --db=postgresql://phil@localhost:5432/v960rc1 --tezos-url=http://localhost:8735 --block-cache-directory=/home/phil/blocks/ Durations: STARTED ON Sun Sep 19 10:21:22 AM PDT 2021 -- TOTAL DURATION: 2h3m53s - apply DB schema from Sun Sep 19 10:21:27 AM PDT 2021 -- duration: 0s - list contract addresses from Sun Sep 19 10:21:27 AM PDT 2021 -- duration: 0s - record contract addresses into DB from Sun Sep 19 10:21:27 AM PDT 2021 -- duration: 7s - start indexing from Sun Sep 19 10:21:34 AM PDT 2021 -- duration: 1h38m48s - conversion of DB from Sun Sep 19 12:00:22 PM PDT 2021 -- duration: 24m53s - average speed: 226 blocks / second, or 13561 blocks per minute, 10208 operations per second ############################ start=Sun Sep 19 10:21:22 AM PDT 2021 end=Sun Sep 19 12:25:16 PM PDT 2021
```
```
0.03user 0.01system 26:29.68elapsed 0%CPU (0avgtext+0avgdata 12460maxresident)k
9896inputs+0outputs (76major+3093minor)pagefaults 0swaps
......
......