Feedback-ID: i76984098:Fastmail
Message-ID: <cd5ad7f0-9506-4828-9c13-88f34e8e4c8c@aklaver.com>
Date: Thu, 24 Jul 2025 07:48:04 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Is there any limit on the number of rows to import using copy
 command
To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>,
 Merlin Moncure <mmoncure@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Pgsql-general <pgsql-general@postgresql.org>
References: <1453510076.1900935.1753260637232.ref@mail.yahoo.com>
 <1453510076.1900935.1753260637232@mail.yahoo.com>
 <CAHyXU0x1uW_349ONE+35KT87Ua-dX8-QaZ5Sj6eENTMwsX=okw@mail.gmail.com>
 <2129916799.2277829.1753359532611@mail.yahoo.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <2129916799.2277829.1753359532611@mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/cd5ad7f0-9506-4828-9c13-88f34e8e4c8c%40aklaver.com>
Precedence: bulk

On 7/24/25 05:18, sivapostgres@yahoo.com wrote:
> Thanks Merlin, adrain, Laurenz
> 
> As a testcase, I split the trigger function into three, one each for 
> insert, update, delete, each called from a separate trigger.
> 
> IT WORKS!.

It worked before, it just slowed down as your cases got bigger. You need 
to provide more information on what test case you used and how you 
define worked.

> 
> Shouldn't we have one trigger function for all the three trigger 
> events?  Is it prohibited for bulk insert like this?

No. Triggers are overhead and they add to the processing that need to be 
done for moving the data into the table. Whether that is an issue is a 
case by case determination.

> 
> I tried this in PGAdmin only, will complete the testing from the program 
> which we are developing, after my return from holiday.

 From Merlin Moncure's post:

"* reconfiguring your logic to a procedure can be a better idea; COPY
your data into some staging tables (perhaps temp, and indexed), then
write to various tables with joins, upserts, etc."

I would suggest looking into implementing the above.

> 
> Happiness Always
> BKR Sivaprakash
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com