Fran Fabrizio <[EMAIL PROTECTED]> writes:
> Another crucial piece of information is that each insert kicks off a
> trigger. I did not write the trigger, and do not know how to write
> triggers, but I think that might be the contributing factor to the
> slowness.
Bingo. Your trigger is adding fo
Hello all,
I'm trying to speed up some insert statements. I have been tinkering
with the postmaster and DBI parameters I did some timings on my insert
and copy commands. Here is a sample insert query:
010430.18:31:18.199 [2604] query: insert into log values
(0,0,lower('blah.blah.mydomain.com