Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 15A01650080 for ; Thu, 7 Aug 2008 12:08:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99471-02 for ; Thu, 7 Aug 2008 12:08:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pih-relay06.plus.net (pih-relay06.plus.net [212.159.14.133]) by postgresql.org (Postfix) with ESMTP id ECA1E64FD00 for ; Thu, 7 Aug 2008 12:08:53 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay06.plus.net with esmtp (Exim) id 1KR76h-0002Lk-Q7; Thu, 07 Aug 2008 16:08:51 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 9969C274053; Thu, 7 Aug 2008 16:08:51 +0100 (BST) Message-ID: <489B1004.4050105@archonet.com> Date: Thu, 07 Aug 2008 16:08:52 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.16 (X11/20080707) MIME-Version: 1.0 To: dforums CC: Pgsql performance Subject: Re: Plz Heeeelp! performance settings References: <35FABCF85D99464FB00BC5123DC2A70A051D0FB8@s228130hz1ew09.apptix-01.savvis.net> <276541.4189.qm@web25805.mail.ukl.yahoo.com> <35FABCF85D99464FB00BC5123DC2A70A051D11E1@s228130hz1ew09.apptix-01.savvis.net> <48908988.7020204@emolecules.com> <1217436578.6288.44.camel@localhost> <1240.1217440309@sss.pgh.pa.us> <1217441061.6288.47.camel@localhost> <489A21C2.8060801@vieonet.com> <489AA5B5.9080109@vieonet.com> <489AB375.3090901@archonet.com> <489ABC8F.4030007@vieonet.com> <489AD118.5010902@archonet.com> <489AF8E8.6070503@vieonet.com> <489B02E6.4010701@archonet.com> <489B06C0.3030305@vieonet.com> In-Reply-To: <489B06C0.3030305@vieonet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: b73e100350b800bb11a1ad3ff4918c84 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/44 X-Sequence-Number: 30925 dforums wrote: > The delete is global, the procedure is called for each line/tracks. > > So - are you calling this function 14000 times to inject your data? > > You're doing this in one transaction, yes? > NO I have to make it 14000 times cause, I use some inserted information > for other insert to make links between data. Why does that stop you putting all 14000 calls in one transaction? -- Richard Huxton Archonet Ltd