Re: [PERFORM] Trigger performance problem

2005-05-17 Thread lists
---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PERFORM] Trigger performance problem

2005-05-17 Thread Tom Lane
"Manuel Wenger" <[EMAIL PROTECTED]> writes: > We're having a performance problem with PostgresQL 8.0.2 running on > RHEL3 Update 4. There is a frequently updated table logging all our ADSL > customer logins which has 2 related triggers. An INSERT on that table, > "calls", takes about 300ms to execu

[PERFORM] Trigger performance problem

2005-05-17 Thread Manuel Wenger
We're having a performance problem with PostgresQL 8.0.2 running on RHEL3 Update 4. There is a frequently updated table logging all our ADSL customer logins which has 2 related triggers. An INSERT on that table, "calls", takes about 300ms to execute according to the logs, and the process takes up t