Configuring PostgreSQL as a Persistence Store in Metarank

OpenSearch
,
1

Configuring PostgreSQL as a Persistence Store in Metarank

Hello everyone,

I’m currently working on integrating PostgreSQL as the persistence store in my Metarank setup instead of Redis. I’ve already gone through the documentation, but I would appreciate any guidance on the correct configuration steps.

Specifically, I’d like to understand:

  1. What are the required settings in metarank.yml to enable PostgreSQL?
  2. Are there any known challenges or performance considerations when using PostgreSQL over Redis?
  3. Does Metarank support a hybrid approach where Redis can be used for hot storage and PostgreSQL for cold storage?

Any insights, examples, or best practices would be greatly appreciated. Thank you in advance!