Connection Pool config
# spicedb
m
Hi 🙂 I'm running SpiceDB with 3 replicas in Azure with Postgres. The default conection limit for managed Postgres is set to 50 or so in Azure. SpiceDB opens about 31 connection per pod when I had a look. Now I'm trying configure pool_max_conns and pool_min_conns which I found in pgx. But the values are ignored. Also in pgx the default min is set to 0, and max is set to 4. But I can't find any place in SpiceDB github regarding the amount of connections. Can someone help me what I am missing here? The connection string I use for SpiceDB: postgres://postgres-postgresql.default.svc.cluster.local:5432/spicedb?user=spicedb&password=&pool_min_conns=1&pool_max_conns=10
v
Hi, SpiceDB Connection Pool is not configured via the DSN, but by providing specific command line arguments (or envs). Please run "spicedb serve --help" to show the ARGS documentation
m
Thanks I'll have a look 🙂
One more questenion, I had a look hat --help. I assume I can set the env variable when I use the env variable
DATASTORE_CONNPOOL_READ_MAX_OPEN
when the start param is
datastore-connpool-read-max-open
. Am I right?
j
You need to add
SPICEDB_
to the front, but otherwise yes.
m
Thanks 🙂
12 Views