Re: How to Copy/Load 1 billions rows into a Partition Tables Fast

Hi Wong On one occasion I had to upload 600 million records, and the most viable and safest option was to generate plans and upload them through a massively parallelized process (because for each process we audited that everything was correct) Atte. JRBM El lun, 14 oct 2024 a las 14:59, Wong, Ka

Re: update faster way

The only way that I see as plausible to use a subquery, both in the query and in the setting of the variable, is that the relationship is one to one, and that there is an index that responds to the predicate UPDATE table1 t1 SET column_value = (SELECT FROM table2 t2 WHERE t2.column_relation = t1.

Re: Manual query vs trigger during data load

Hello, I find it unlikely that the trigger will work properly, since the reserved fields of the OLD subset have no value in an INSERT Atte JRBN El vie, 13 de sept de 2024, 04:32, yudhi s escribió: > Hello All, > > We are having a table which is going to be inserted with 100's of millions > of r

Re: can stored procedures with computational sql queries improve API performance?

Great tip!!! Thx El mié, 10 de jul de 2024, 16:17, Ron Johnson escribió: > On Tue, Jul 9, 2024 at 8:58 PM Krishnakant Mane > wrote: > >> Hello. >> >> I have a straight forward question, but I am just trying to analyze the >> specifics. >> >> So I have a set of queries depending on each other in

Re: Dll libpq.dll 32 bits

e. >> JRBM >> >> El jue, 30 may 2024 a las 13:27, José Mello Júnior (< >> jose.mello.jun...@gmail.com>) escribió: >> >>> No, I can´t use ODBC in this case, because I only access a new server. I >>> need the DLL in 32 bits. >>> >&g

Re: Dll libpq.dll 32 bits

C in this case, because I only access a new server. I > need the DLL in 32 bits. > > Atte > Mello > > Em qua., 29 de mai. de 2024 às 23:45, Juan Rodrigo Alejandro Burgos Mella < > rodrigoburgosme...@gmail.com> escreveu: > >> you can use ODBC with Windev

Re: Dll libpq.dll 32 bits

you can use ODBC with Windev, so the best is the Postgresql connector https://www.postgresql.org/ftp/odbc/releases/ Atte JRBM El mié, 29 may 2024 a las 14:46, José Mello Júnior (< jose.mello.jun...@gmail.com>) escribió: > > Em qua., 29 de mai. de 2024, 15:41, Adrian Klaver < > adrian.kla...@akla

Re: Controlling resource utilization

In postgreSQL, that can be done at a session level, or at a general level (in the postgresql.conf configuration file) Atte JRBM El mar, 16 abr 2024 a las 15:18, yudhi s () escribió: > > > On Wed, 17 Apr, 2024, 1:32 am Juan Rodrigo Alejandro Burgos Mella, < > rodrigoburgosme...@g

Re: Controlling resource utilization

Yes sir SET statement_timeout TO '' Atte JRBM El mar, 16 abr 2024 a las 14:46, yudhi s () escribió: > Hi , > We want to have controls around the DB resource utilization by the adhoc > user queries, so that it won't impact the application queries negatively. > Its RDS postgresql database version

Re: Trigger to Count Number of Logical Replication Table Changes.

Hi The only thing that can be established is that if the record does not exist, the trigger will not be updating anything in the table "tst.time_audit_tbl" for the condition "table_name = CONCAT(TG_TABLE_SCHEMA, '.', TG_TABLE_NAME)" Maybe, checking before the UPDATE, if the record does not exist,

Re: My question about the transaction

By default, psql is configured with autocommit on. Use another administrator, like phpadmin, and configure the connection with autocommit off. Atte JRBM El jue, 19 oct 2023 a las 11:49, Wen Yi () escribió: > Hi community, > I am learning the transaction of the postgresql, and I try to test using

ECPG Semantic Analysis

Hi I have a modified version of ECPG, to which I gave the ability to do semantic analysis of SQL statements. Where can you share it or with whom can I discuss it? Atte. JRBM