Re: [GENERAL] DBI/AutoCommit/Postgres

2001-04-30 Thread Tom Lane
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

[GENERAL] DBI/AutoCommit/Postgres

2001-04-30 Thread Fran Fabrizio
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