Re: How to trace the postgres?

2023-06-12 Thread Wen Yi
That's works, Thanks very much! Yours, Wen Yi   -- Original -- From: "Junwang Zhao"

Re: Question about where to deploy the business logics for data processing

2023-06-12 Thread Merlin Moncure
On Thu, Jun 8, 2023 at 10:22 PM Nim Li wrote: > I wonder if anyone in the community has gone through changes like this? I > mean ... moving the business logics from PL/SQL within the database to the > codes in NestJS framework, and reply on only the TypeORM to manage the > update of the database

Re: Dynamic binding issue

2023-06-12 Thread Adrian Klaver
On 6/12/23 15:13, Lorusso Domenico wrote: Hello guys, I'm a problem with dynamic sql. I am trying to write a generic function that is able to read and update a table based on some data coming from e previous record. Here the example _sqlStr=format('select *   from  %1$s.%2$s   where (' || arr

Dynamic binding issue

2023-06-12 Thread Lorusso Domenico
Hello guys, I'm a problem with dynamic sql. I am trying to write a generic function that is able to read and update a table based on some data coming from e previous record. Here the example _sqlStr=format('select * from %1$s.%2$s where (' || array_to_string(_activeRec.pk_columns_list, ',') ||

Re: Question about where to deploy the business logics for data processing

2023-06-12 Thread Lorusso Domenico
Hi Nim, well this is a very particular scenario. In a few words, these projects will never go live for production purposes, but just to verify some hypotheses. In this case, could be acceptable to generate schema on the fly, but isn't easy to automatize each aspect related to optimization (partiti

How to trace the postgres?

2023-06-12 Thread Wen Yi
Hi team, Now I am start to analyse the process of the postgres, using the gdb. As you can see, at the beginnning of my work, I use the ps to find the postgres's process. [postgres@fedora postgresql]$ ps -ef | grep postgres postgres   67468    1599  0 08:11 ?    00:00:01 /home/postgres/pgsq