RE: Postgres and Java Microservices Multithreading

Hi Experts,

Few more details as discussed with application team.

In parallel processing Application will create multiple threads towards our PG database to retrieve/ update data.

1. Application will send multiple parallel requests to DB on same table to SELECT data.
2. Application will send multiple parallel requests to DB on same table to UPDATE data
3. Application will send multiple parallel requests to DB on same table to INSERT data

Thanks..

From: Bhattacharjee, Soumik
Sent: donderdag 5 december 2019 10:48
To: 'pgsql-admin(at)lists(dot)postgresql(dot)org' <pgsql-admin(at)lists(dot)postgresql(dot)org>; 'pgsql-admin(at)postgresql(dot)org' <pgsql-admin(at)postgresql(dot)org>
Subject: RE: Postgres and Java Microservices Multithreading

Hi Experts,

Please let me know if you have some use cases or documentations around this.

Any response will help me a lot in this context.

Thanks in advance.

From: Bhattacharjee, Soumik
Sent: woensdag 4 december 2019 14:34
To: 'pgsql-admin(at)lists(dot)postgresql(dot)org' <pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org>>; pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>
Subject: Postgres and Java Microservices Multithreading

Hi Experts,

To set the context we are operating in Oracle 11g R2 and our applications are deployed in private cloud and all 15 + Java micro services are multithreaded.

And we are doing database migration from Oracle 11gR2 to Postgres 12.

So if anyone can share your experience or share some documentations/use cases if we can maintain the same configurations for Java micro services with multithreading as we are using in Oracle and same works in Postgres too? - (We just plan to switch the data source from Oracle to Postgres- will that work? )

Thanks..