What is the best way to do this in Postgres
| От | kunwar singh |
|---|---|
| Тема | What is the best way to do this in Postgres |
| Дата | |
| Msg-id | CAJSrDUoBN0KGdBdQKD_tjUFM2LJipefJuQ5GpQrY2iFm8Y2J3Q@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: What is the best way to do this in Postgres
Re: What is the best way to do this in Postgres |
| Список | pgsql-sql |
Hello Listers,
Looking for your inputs on the most efficient way to do it in Postgres.
What I want to do:
===
I want to spawn 10 concurrent sessions each executing a complex stored procedure with one of the parameters being the product ID.
Example
CALL process_product(curdate, region, productid=>1) ;
CALL process_product(curdate, region, productid=>2) ;
CALL process_product(curdate, region, productid=>3) ;
CALL process_product(curdate, region, productid=>4) ;
...
CALL process_product(curdate, region, productid=>10) ;
Say I get a list of product IDs by running a big query
Product ID
====
1
2
3
4
..
10
Additional Information
===
Everytime number of product ids will change. At a given time there should be no more than 10 concurrent sessions of process_product.
I want to trigger these procedure calls once every hour. For a given hour the number of product IDs could range from 10 to 100 in total.
I am using RDS Postgres v 15.
Question
===
I know I can create a bash script or Python script , but I am wondering if there is a smarter way to do it in Postgres?
Cheers,
Kunwar
Kunwar
В списке pgsql-sql по дате отправления: