Execute two queries at the same time on psql with node postgres

Question

I have two independent queries for example:

const query = "SELECT PG_SLEEP(30);"
const query1 = "SELECT PG_SLEEP(30);"

console.time("Query")
await Promise.all([pgClient.query(query), pgClient.query(query1)]);
console.timeEnd("Query")

This, according to the documentation, will be added to a queue and execute one after the other, is it possible to execute the two queries asynchronously? so the registered time should be around 30 instead of 60...

UPDATE: Other approach would be to use the pool feature of the library instead of instantiating two clients

Laurenz Albe · Accepted Answer · 2022-01-12 14:27:27Z

1

For that, you have to open two database connections. Then it is no problem to have two queries running concurrently.

answered Jan 12, 2022 at 14:27

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

IBot Over a year ago

Yeap that works too, I thought there's a way w/o using that approach

Laurenz Albe Over a year ago

No, that is the only way.

Collectives™ on Stack Overflow

Execute two queries at the same time on psql with node postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related