First witness update log of 2023.
techcoderx.com updated
Over the last week, the API node has been updated to v1.27.3 and its corresponding HAF-based Hivemind v1.27.3.0.0. It is an important hived update that had to be made as it contains node-crashing fixes especially for public API nodes.
HAF Hivemind
This is a significant release of Hivemind due to the transition to using HAF data natively instead of HTTP-based state providers (HAfAH or traditional hived API). It was a 2.5 day sync (2 days for massive sync and 0.5 days for post-sync hooks), much better than 5-7 days the last time it went through the whole process from scratch some years ago (hardware wasn't as good at those times but blockchain was smaller).
The latest Hivemind is also noticeably quicker in query times as certain feeds (such as C/LeoFinance) loaded within ~0.5 seconds instead of somewhere between 3-5 seconds.
Deploying PostgREST HAfAH
Due to some dependency conflicts, I have looked into PostgREST and managed to install and run it successfully. PostgREST usually performs better at API queries than the Python variant.
The HAF node setup guide has been updated for the new releases and PostgREST HAfAH deployment instructions.
What's next
This is by no means a detailed roadmap, but some of the things I would like to accomplish this year:
Olisc API
Now that OneLoveIPFS v3 is out along with v3.0.1 follow-up, the Olisc API would be the first thing in the list to be finalized and deployed.
This would enable scheduled publishing on the hosting service. There will be no desktop app updates solely for this as it was already integrated in the renderer.
Update (11 Jan 2023 02:30 UTC): Olisc API is now deployed, non-3Speak uploads may now schedule their videos to be published by setting the date and time under the advanced tab.
HAF-based Alive Protocol
The highly overdue HLS live streaming protocol 
The framework (along with OBI) will be beneficial for the protocol as it will properly handle stream chunk batches in an event of a fork so they will not go out of place during a live event.
More details incoming once I look into it.
Witness performance
Current rank: 85th (active rank 80th)
Votes: 5,020 MVests
Voter count: 295
Producer rewards (7 days): 30.202 HP
Producer rewards (30 days): 136.515 HP
Missed blocks (all-time): 29
Server resource statistics
hived (v1.27.3, 2a79d97f, all plugins)
block_log file size (compressed): 376 GB
block_log.artifacts file size: 1.6 GB
shared_memory.bin file size: 21 GB
HAF db
All HAF apps (including Hivemind) belong to individual schemas in a single PostgreSQL database. This section shows the sizes of each schema in the database using the following query:
SELECT schemaname,
pg_size_pretty(SUM(pg_total_relation_size(relid))) AS total_size,
pg_size_pretty(SUM(pg_table_size(relid))) AS table_size,
pg_size_pretty(SUM(pg_indexes_size(relid))) AS indexes_size
FROM pg_catalog.pg_statio_user_tables
GROUP BY schemaname;
Output
schemaname | total_size | table_size | indexes_size
--------------+------------+------------+--------------
hivemind_app | 656 GB | 345 GB | 311 GB
hive | 3333 GB | 2211 GB | 1122 GB
hafah_python | 16 kB | 16 kB | 0 bytes
(3 rows)
Overall Postgres database
RAM usage: 46 GB
Compressed disk usage: 1.6 TB
Compression ratio: 2.51x
