Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1icq9u-0005wi-UJ for pgsql-admin@arkaria.postgresql.org; Thu, 05 Dec 2019 12:23:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1icq9t-000102-O7 for pgsql-admin@arkaria.postgresql.org; Thu, 05 Dec 2019 12:23:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1icq9t-0000zv-Ay for pgsql-admin@lists.postgresql.org; Thu, 05 Dec 2019 12:23:01 +0000 Received: from cpdelvb-safe104.kpnxchange.com ([195.121.3.38]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1icq9p-00052M-8I for pgsql-admin@lists.postgresql.org; Thu, 05 Dec 2019 12:23:00 +0000 Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_2A91BEF8171A5349931391E0C721CC5375705457CPEMSKPN501KPNC_" DKIM-Signature: v=1; a=rsa-sha256; d=kpn.com; s=safemail01; c=relaxed/relaxed; t=1575548575; h=mime-version:date:message-id:subject:from:to:content-type; bh=kaNPGN8jhL9/mxl0N6NFwRzqymka47l8y1WzAJs4FcU=; b=T5E0Pqh3LglfMvMWSqozJ33YlLRXsK7xyVvGFPid527nOOD+urxThit3/cLXVSSXQeaeOGmqrgp gk/+LB4QDUffIFeJRHX54aTXeqPXcdO6GhSiKZNscZbKCCyvd5CP6eQ2EPzWBT+uxQ+tn119ZkLlR Rn7RI/Vb7Fq9AAziXM8= Received: from CPSUBM-SAFE105.kpnxchange.com ([10.94.186.34]) by cpdelvb-safe104.kpnxchange.com with Microsoft SMTPSVC(8.5.9600.16384); Thu, 5 Dec 2019 13:22:55 +0100 X-KPNSenderID: 4294967167 Received: from CPEMS-KPN302.KPNCNL.LOCAL ([145.128.1.60]) by CPSUBM-SAFE105.kpnxchange.com over TLS secured channel with Microsoft SMTPSVC(8.5.9600.16384); Thu, 5 Dec 2019 13:22:55 +0100 Received: from CPEMS-KPN501.KPNCNL.LOCAL ([fe80::e91d:e9d:8514:2118]) by CPEMS-KPN302.KPNCNL.LOCAL ([fe80::ac40:2dac:52f3:7d08%12]) with mapi id 14.03.0439.000; Thu, 5 Dec 2019 13:22:55 +0100 From: To: , Subject: RE: Postgres and Java Microservices Multithreading Thread-Topic: Postgres and Java Microservices Multithreading Thread-Index: AdWqpn/R4t61EWEpQvqpXv9jDosTyAAql+uwAAVvOmA= Date: Thu, 5 Dec 2019 12:22:54 +0000 Message-ID: <2A91BEF8171A5349931391E0C721CC5375705457@CPEMS-KPN501.KPNCNL.LOCAL> Accept-Language: nl-NL, en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.75.185.178] MIME-Version: 1.0 X-OriginalArrivalTime: 05 Dec 2019 12:22:55.0604 (UTC) FILETIME=[B8FF2340:01D5AB66] X-RcptDomain: lists.postgresql.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_2A91BEF8171A5349931391E0C721CC5375705457CPEMSKPN501KPNC_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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@lists.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@postgresql.org Subject: Postgres and Java Microservices Multithreading Hi Experts, To set the context we are operating in Oracle 11g R2 and our applications a= re deployed in private cloud and all 15 + Java micro services are multithr= eaded. And we are doing database migration from Oracle 11gR2 to Postgres 12. So if anyone can share your experience or share some documentations/use cas= es 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.. --_000_2A91BEF8171A5349931391E0C721CC5375705457CPEMSKPN501KPNC_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Expe= rts,

&n= bsp;

Few mor= e details as discussed with application team.

&n= bsp;

In para= llel processing Application will create multiple threads towards our PG dat= abase to retrieve/ update data.

&n= bsp;

&n= bsp;

  1. Application will send multiple parallel requests to DB on= same table to SELECT data.
  2. Applica= tion will send multiple parallel requests to DB on same table to UPDATE dat= a
  3. Application will send multiple pa= rallel requests to DB on same table to INSERT data

    4.  

     

    &n= bsp;

    Thanks..

     

    From: Bhattacharjee, Soumik
    Sent: donderdag 5 december 2019 10:48
    To: 'pgsql-admin@lists.postgresql.org' <pgsql-admin@lists.postgre= sql.org>; 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>= ;
    Subject: RE: Postgres and Java Microservices Multithreading

     

    Hi Expe= rts,

    &n= bsp;

    Please = let me know if you have some use cases or documentations around this.<= /o:p>

    &n= bsp;

    Any res= ponse will help me a lot in this context.

    &n= bsp;

    Thanks = in advance.

    &n= bsp;

     

    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 opera= ting in Oracle 11g R2 and our applications are deployed in private cloud an= d all 15 +  Java micro services are multithreaded.

     

    And we are doing database migra= tion from Oracle 11gR2 to Postgres 12.

     

    So if anyone can share your exp= erience or share some documentations/use cases if  we can maintain the sam= e configurations for Java micro services with multithreading as we are usin= g in Oracle and same works in Postgres too? – (We just pl= an to switch the data source from Oracle to Postgres- will that work? )

     =

     =

    Thanks..

     

--_000_2A91BEF8171A5349931391E0C721CC5375705457CPEMSKPN501KPNC_--