Skip to content
GitLab
Menu
Why GitLab
Pricing
Contact Sales
Explore
Why GitLab
Pricing
Contact Sales
Explore
Sign in
Get free trial
Changes
Page history
Update benchmarks
authored
Sep 19, 2021
by
Philippe Wang
Show whitespace changes
Inline
Side-by-side
benchmarks.md
View page @
6d0b89f7
...
...
@@ -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
...
...
...
...