A
A
alex_kulkoff2019-08-15 09:09:45
PostgreSQL
alex_kulkoff, 2019-08-15 09:09:45

Sequelize setting. How many connections?

Hello.
I am writing a small service, there will be about 100 active users. Currently, local settings are as follows:

host: 'localhost',
  dialect: 'postgres',
  pool: {
    max: 5,
    min: 0,
    acquire: 30000,
    idle: 10000
  }

How much should be set in pool.max for 100 users?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey, 2019-08-15
@alex_kulkoff

"Active Users" is too generic name, what exactly is on this service? Chat, static site, currency exchange, real-time auction ?
I can offer this answer.

pool.max = 1;
while(notGoodEnough) {
 pool.max++;
}

In general, for such a meager number of users, 1 connection without a pool is enough.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question