RAM usage with Stat Building



  • The stat building process uses more and more RAM as time passes. For a large database the process will eventually run out of RAM and crash - it's not a case of if but when. Even if windows swap file (paging) were to be used, a crash is inevitable.

    Process ideally needs to use a finite amount of RAM and save stats to the postgres DB at regular intervals in order to clear the RAM cache and prevent crashing.

    With current setup it's basically impossible to build stats for databases over a certain size.



  • This will be fixed in Hand2Note 4. We are working on it actively. There is no any ETA right now.

    For now only can suggest not to keep it very big and to do occasionally some maintenance in PgAdmin

    You may do maintenance using PgAdmin, which is distributed with Hand2Note and may be started in Hand2Note/pgsql/bin/pgAdmin3.exe
    0_1615884117594_upload-0439109c-49d1-456f-8609-20b772f8cbd5

    0_1615884131947_upload-77930139-eb10-4b20-b5fe-42a40e1b45eb


Log in to reply
 

Looks like your connection to Hand2Note was lost, please wait while we try to reconnect.