1. Intro
  2. Milestone 2: DNO (Dando Node Operator) funding - 50.000 ADA

    1. Q is making blocks on Dando gov

    2. Show large table sizes

      SELECT

      schemaname,

      relname,

      pg_size_pretty(pg_total_relation_size(relid)) AS total_size

      FROM

      pg_catalog.pg_statio_user_tables

      ORDER BY

      pg_total_relation_size(relid) DESC;

    3. Start sync only on node and db-sync. Then cardano-graphql-background. Bring them down and then do a VACUUM FULL;

  3. Milestone 3: Education
  4. Milestone 4: Maintenance
    1. Setting -c max_wal_size=8GB on POSTGRES_ARGS in .env
    2. Cron job for a weekly VACUUM FULL;