RE: Postgres and Java Microservices Multithreading - Mailing list pgsql-admin
| From | |
|---|---|
| Subject | RE: Postgres and Java Microservices Multithreading |
| Date | |
| Msg-id | 2A91BEF8171A5349931391E0C721CC53757054D3@CPEMS-KPN501.KPNCNL.LOCAL Whole thread Raw |
| In response to | Re: Postgres and Java Microservices Multithreading ("Peter M. Groen" <peter@osdev.nl>) |
| Responses |
Re: Postgres and Java Microservices Multithreading
Re: Postgres and Java Microservices Multithreading |
| List | pgsql-admin |
Thanks Peter for your response, appreciate much.
But I think the applications wont behave the same way as with Oracle.(We have 15+ Microservices running in Oracle with parallel processing)
Below I just checked and testing in Test Env.
https://www.postgresql.org/docs/12/parallel-query.html
https://dzone.com/articles/postgresql-connection-pooling-part-1-pros-amp-cons
If anyone have some use cases/real time project executions will be really helpful.
Thanks..
From: Peter M. Groen <peter@osdev.nl>
Sent: donderdag 5 december 2019 13:30
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; pgsql-admin@lists.postgresql.org; pgsql-admin@postgresql.org
Subject: Re: Postgres and Java Microservices Multithreading
There is no reason why it shouldn't work as long as you use the database only as a data storage and all the java-stuff is as a separate layer in your software.
Conversion problems can happen on data-types, constraints and/or triggers. If you use stored-procedures, those should be converted / rewritten as well..
A bit of a strange question as this is basic datbase knowledge.... ??/ Esp. if you're working at KPN.
--
Open Systems Development B.V.
Peter M. Groen
Managing Director
Rooseveltstraat 18-P
2321 BM Leiden
+31 6 12 08 95 62
email : peter@osdev.nl
skype : peter_m_groen
On Thu, 2019-12-05 at 12:22 +0000, soumik.bhattacharjee@kpn.com wrote:
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@lists.postgresql.org' <pgsql-admin@lists.postgresql.org>; 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.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@lists.postgresql.org' <pgsql-admin@lists.postgresql.org>; pgsql-admin@postgresql.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..
pgsql-admin by date: