If not, and you have one near, what would be the size of it for the Mainnet?

Number of transactions significantly increased on Algorand starting May 2020. See Algorand Stats , tab “transactions” The above comment is no more relevant for MainNet. You can do a PR to the repo to fix this comment.

https://howbigisalgorand.com/ indicates the size of all the databases together. Today MainNet is: 495GB according to SELECT pg_size_pretty( pg_database_size('mainnet')); pg_dump may compress things and may be shorter.

What about this 1:100 ratio from the Indexer README ? As of April 2020, storing all the raw blocks is about 100 GB and the PostgreSQL database of transactions and accounts is about 1 GB. Much of that size difference is the Indexer ignoring cryptographic signature data; relying on algod to validate …

Thank you for your effort and a quick response!

[image] Algoscan Algoscan is a Blockchain Explorer and Analytics Platform allowing you to search the Algorand Blockchain for addresses, ASAs/assets, transactions, blocks, smart contracts, NFTs, and view several statistics/metrics about the Algorand Network. D…

Does anybody have a link to a pg_dump of the Indexer database?

General

ipaleka August 9, 2021, 11:48am 6

Data is live and based off our nodes currently running on AWS. Contact us if you’re interested in a full backup copy of our Archival Nodes/Indexer.

Topic		Replies	Views
What's the current mainnet & testnet archival node's ledger data size? General	18	3192	April 23, 2022
Thoughts on running a node and indexer using a Raspberry Pi 4 8GB RAM and 4TB HDD General	3	566	January 3, 2022
How much disk space on Ubuntu is needed to fully sink algorand node?	2	784	February 12, 2020
What is the database used to write the ledger records? General	4	757	January 28, 2022
How big can the Algorand Blockchain get before problems start occurring?	5	3172	June 17, 2022

Does anybody have a link to a pg_dump of the Indexer database?

Related topics