[back] optim: make cache table UNLOGGED

[amatissart]

Description

Configure the cache table in Postgres as UNLOGGED could help to reduce the load on the db, as the API throttles are currently responsible for a lot of queries in the cache.

Find more details about using unlogged table as a cache in PostgreSQL: https://martinheinz.dev/blog/105

An alternative would be to use Redis as a cache instead of PostgreSQL. Possibly more performant, but requires more changes in infra and dev-env.

Checklist

• [x] I added the related issue(s) id in the related issues section (if any)
  • if not, delete the related issues section
• [x] I described my changes and my decisions in the PR description
• [x] I read the development guidelines of the CONTRIBUTING.md
• [x] The tests pass and have been updated if relevant
• [x] The code quality check pass