Greetings Hive minds! I'm a long time PostgreSQL contributor and author specializing in performance tuning. Now that @mahdiyari has the PostgreSQL based [HafSQL in beta](https://ecency.com/hive-139531/@mahdiyari/hafsql-v100-beta), I noticed index building is becoming a serious drag. Thought I'd share my last conference video as possibly helpful: [Speedrunning the Open Street Map osm2pgsql Loader](https://www.youtube.com/watch?v=BCMnu7xay2Y)
That took the roughly terabyte sized Open Street Map Planet data set and re-tuned everything for NVMe to drop loading time, which on current hardware I now have down to just over 4 hours. All the config changes to PG and Linux are documented. HafSQL's starter postgresql.conf probably needs less shared_buffers and more maintenance_work_mem to speed all its index builds up; few disk GB of max_wal_size first would help too. Hoping to get the full Hive data set running here so I can test myself.
Day job at Crunchy Data is 100% open source work like multi-cloud PostgreSQL. I run a benchmark lab and the Hive blockchain makes a nice sized data set for my upcoming work.