Update in trigger

From: Iklódi Lajos <il(at)mithrandir(dot)hu>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Update in trigger
Date: 2002-04-03 03:38:42
Message-ID: 3CAA7942.592D079B@mithrandir.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I have a problem with trigger in 7.1.3.
I have a table with after insert trigger, which is making updates in
another table.
I recognized that the more records I have in first table the slower is
my insert.
If my trigger is doing something else, for example inserts in another
table, it becomes * 20 times * quicker, and the speed of my insert
doesn't depend on tablesize.
Don't I have to make updates in trigger?

Thanks in advance for any help.
Lajos

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message cristi 2002-04-03 06:10:39 Date
Previous Message John Proctor 2002-04-03 02:50:52 16 parameter limit