Title
#help
a

Amy Soetopo

08/19/2022, 4:44 AM
Quick question: in a production setting, we are planning to use PostgreSQL for policy storage. From what I understand, Cerbos reads from the DB, loads the policies into memory, and then after - is the connection to the data store kept alive?
Charith (Cerbos)

Charith (Cerbos)

08/19/2022, 7:52 AM
Hi. Cerbos doesn't load all policies into memory. They are loaded from the database lazily when accessed and then cached. You can configure the database connection pool settings to define how long idle connections are kept open and so on. https://docs.cerbos.dev/cerbos/latest/configuration/storage.html#_connection_pool
a

Amy Soetopo

08/19/2022, 6:28 PM
Oh, okay perfect, thank you for clarifying!