https://supertokens.com/ logo
Title
c

cuteprogrammer

03/02/2023, 12:21 PM
I get this result when I run this query. SELECT * FROM pg_stat_activity;
r

rp

03/02/2023, 12:22 PM
hey @cuteprogrammer whats the config for the db connection pool size in the core that you have set?
c

cuteprogrammer

03/02/2023, 12:24 PM
In my docker-compose.yml file, POSTGRESQL_CONNECTION_URI: "postgresql://supertokens_user:somePassword@db:5432/supertokens"
r

rp

03/02/2023, 12:25 PM
have you provided any other config to the core?
c

cuteprogrammer

03/02/2023, 12:25 PM
No
r

rp

03/02/2023, 12:25 PM
hmm
oh right.
So the default value of the connection pool size is 10
you can change it by setting the postgresql_connection_pool_size env var in the docker compose file
c

cuteprogrammer

03/02/2023, 12:26 PM
okay thanks