RE: Postgres and Java Microservices Multithreading

<soumik.bhattacharjee@xxxxxxx> · Thu, 5 Dec 2019 12:22:54 +0000

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.

Application will send multiple parallel requests to DB on same table to SELECT data.
Application will send multiple parallel requests to DB on same table to UPDATE data
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@xxxxxxxxxxxxxxxxxxxx' <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>; 'pgsql-admin@xxxxxxxxxxxxxx' <pgsql-admin@xxxxxxxxxxxxxx>

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@xxxxxxxxxxxxxxxxxxxx' <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>;
pgsql-admin@xxxxxxxxxxxxxx

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..