[Deliverable] PostgreSQL Optimisation phase 1

[chair28980]

Continue work to improve PostgreSQL query performance. Focus on queries with direct impact on UX. E.g. hash query to get store message confirmation.

Stress-testing of store queries by the Waku testing engineer has started and can be used as a baseline. Also, a dashboard will be built to better track store performance over time.

Following activities will be performed:

• Review of store stressing test results and tackle inconsistency and poor performance
• Review with PostgreSQL expert (IFT CC) potential improvements and implement them

Stress testing of Waku Store can be used as a base to measure the gains from the optimization. Two phases are expected:

• Preliminary work with IFT CC to cover basis and prepare for consultation (phase 1)
• Consultation with an external agency for fine tuning. (phase 2, separate deliverable and milestone)