X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 25E099DC948 for ; Tue, 28 Feb 2006 01:04:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24928-10 for ; Tue, 28 Feb 2006 01:04:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 809089DC80C for ; Tue, 28 Feb 2006 01:04:08 -0400 (AST) Received: from [192.168.178.99] (p548B3E77.dip0.t-ipconnect.de [84.139.62.119]) by service-web.de (Postfix) with ESMTP id 22F1B20002A; Tue, 28 Feb 2006 06:04:09 +0100 (CET) Message-ID: <4403D9C5.20301@wildenhain.de> Date: Tue, 28 Feb 2006 06:04:05 +0100 From: Tino Wildenhain User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: "Jeevanandam, Kathirvel (IE10)" Cc: pgsql-general@postgresql.org Subject: triggers, performance Was: Re: rotate records References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.128 required=5 tests=[AWL=0.128] X-Spam-Score: 0.128 X-Spam-Level: X-Archive-Number: 200602/1164 X-Sequence-Number: 91829 Jeevanandam, Kathirvel (IE10) schrieb: > Hi all, > > I am facing performance issues even with less than 3000 records, I am > using Triggers/SPs in all the tables. What could be the problem. > Any idea it is good to use triggers w.r.t performance? Much to general. What triggers? (what are they doing, when are they invoked...?). Please provide much greater details with your request or nobody can help. Regards Tino PS: and try not to steal threads