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 1icqGi-000691-I8 for pgsql-admin@arkaria.postgresql.org; Thu, 05 Dec 2019 12:30:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1icqGh-0006PZ-9r for pgsql-admin@arkaria.postgresql.org; Thu, 05 Dec 2019 12:30:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1icqGg-0006Ip-Iw; Thu, 05 Dec 2019 12:30:02 +0000 Received: from 87-253-140-15.colo.transip.net ([87.253.140.15] helo=mail.osdev.nl) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1icqGd-0003FG-JE; Thu, 05 Dec 2019 12:30:01 +0000 X-Clacks-Overhead: "GNU Terry Pratchett" Received: from optiplex64.osdev.nl (83-160-143-48.ip.xs4all.nl [83.160.143.48]) (authenticated bits=0) by mail.osdev.nl (8.14.4/8.14.4) with ESMTP id xB5CTsh9031475 (version=TLSv1/SSLv3 cipher=AES256-GCM-SHA384 bits=256 verify=NO); Thu, 5 Dec 2019 13:29:54 +0100 Message-ID: <251962385fdc49da0da54e22588aabd6fbc2e0fa.camel@osdev.nl> Subject: Re: Postgres and Java Microservices Multithreading From: "Peter M. Groen" To: soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.org, pgsql-admin@postgresql.org Date: Thu, 05 Dec 2019 13:29:54 +0100 In-Reply-To: <2A91BEF8171A5349931391E0C721CC5375705457@CPEMS-KPN501.KPNCNL.LOCAL> References: <2A91BEF8171A5349931391E0C721CC5375705457@CPEMS-KPN501.KPNCNL.LOCAL> Disposition-Notification-To: peter@osdev.nl Organization: Open Systems Development B.V. Content-Type: multipart/alternative; boundary="=-PhVqChfs+/ZcNM6vqbxF" User-Agent: Evolution 3.34.2 (3.34.2-1.fc31) MIME-Version: 1.0 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.5.12 (mail.osdev.nl [87.253.140.15]); Thu, 05 Dec 2019 13:29:54 +0100 (CET) X-Spam-Status: No, score=-1.8 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, UNPARSEABLE_RELAY,URIBL_BLOCKED autolearn=ham version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on bohr.osdev.nl List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=-PhVqChfs+/ZcNM6vqbxF Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit 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. 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 dataApplication 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.. > > > > -- 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 --=-PhVqChfs+/ZcNM6vqbxF Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
There is n= o reason why it shouldn't work as long as you use the database only as a da= ta storage and all the java-stuff is as a separate layer in your software.<= /div>
Conversion problems can happen on data-types, constraints and/or = triggers. If you use stored-procedures, those should be converted / rewritt= en as well..

A bit of a strange question as this i= s basic datbase knowledge.... ??/ Esp. if you're working at KPN. 
--
Open Systems Developme= nt B.V.
Peter M. Groen
Managing Director
Roosevelts= traat 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:
<= blockquote type=3D"cite" style=3D"margin:0 0 0 .8ex; border-left:2px #729fc= f solid;padding-left:1ex">

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? =E2=80=93 (We just = plan to switch the data source from Oracle to Postgres- will that work? )

     =

     =

    Thanks..

     

--=-PhVqChfs+/ZcNM6vqbxF--