[Epic] PostgreSQL in service node: Further optimisations

[fryorcraken]

Epic label: E:PostgreSQL

Summary

Further optimisation of PosgreSQL usage for Waku archive in nwaku.
Specifically to cover the case of Status Communities and 10k users in a given Community/shard/store.

Acceptance Criteria

• Various optimization/performance fix have been implementing.
• Performance analysis done and follow-up items are implemented.

Note that while go-waku also implements PostgresSQL, the focus is on nwaku as a service node.
Providing store service from Status Desktop app is not part of the scope of this epic.
This will be possible/interesting once #57 is done.

Tasks

• nwaku: chore (postgres): Establish a testing environment and tooling to measure Store performance nwaku#1894
• nwaku: chore (postgres): Make nwaku to reconnect to the Postgres database if it restarts nwaku#1893
• nwaku: PostgreSQL nwaku#1888
• nwaku: Add retention policy with GB or MB limitation nwaku#1885
• nwaku: chore(postgres): Optimize the database.  nwaku#1842
• nwaku: chore(postgres): keep the Postgres queries in separate raw files. nwaku#1841
• nwaku: chore(postgres): Create a docker file to bring nwaku + PostgreSQL simultaneously. nwaku#1840
• nwaku: chore(archive): allow request concurrency towards PostgreSQL nwaku#1604

RAID (Risks, Assumptions, Issues and Dependencies)