Swap memory in orion

[ignazio-bovo]

On orion production machine we have:

• RAM: 64 GB
• SWAP: 4 GB
• swappiness parameter: 1 (minimum swap usage, ie the linux kernel will use the swap memory the least amount possible)

Problem

even with minimal usage the swap memory tends to fill up and whan it does the normal db queries used for example to load the gleev home page becomes incredibly slow (16 sec).

Solution

add a script to be run periodically say once a week in order to have the swap cleaned

@attemka raised concerns about the archive gateway swap usage (reporting up to 2220532 kB of swap in critical conditions) , I believe that now in the newer version the Subsquid team has deprecated support for self-hosted archive in favour of an archive managed by them under a monthly subscription via credit card.
This would solve the current problem if presented, and also providing more up to date anchive infrastructure