Received: from mx2.datanet.hu (unknown [194.149.13.163]) by postgresql.org (Postfix) with ESMTP id D3B50475452 for ; Tue, 2 Apr 2002 22:37:46 -0500 (EST) Received: from mithrandir.hu (tiszaujvaros2-31.dialin.datanet.hu [195.56.11.222]) by mx2.datanet.hu (DataNet) with ESMTP id 3668C5A22; Wed, 3 Apr 2002 05:37:50 +0200 (CEST) Message-ID: <3CAA7942.592D079B@mithrandir.hu> Date: Wed, 03 Apr 2002 05:38:42 +0200 From: =?iso-8859-2?Q?Ikl=F3di?= Lajos X-Mailer: Mozilla 4.51 [hu] (WinNT; I) X-Accept-Language: hu MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Update in trigger Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/26 X-Sequence-Number: 7291 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