Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A19BF650158 for ; Fri, 18 Jul 2008 14:23:05 -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 66759-08 for ; Fri, 18 Jul 2008 14:23:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n13a.bullet.mail.mud.yahoo.com (n13a.bullet.mail.mud.yahoo.com [68.142.207.51]) by postgresql.org (Postfix) with SMTP id 7BCB265015C for ; Fri, 18 Jul 2008 14:23:01 -0300 (ADT) Received: from [68.142.200.221] by n13.bullet.mail.mud.yahoo.com with NNFMP; 18 Jul 2008 17:23:00 -0000 Received: from [76.13.13.26] by t9.bullet.mud.yahoo.com with NNFMP; 18 Jul 2008 17:23:00 -0000 Received: from [76.13.10.171] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 18 Jul 2008 17:23:00 -0000 Received: from [127.0.0.1] by omp112.mail.ac4.yahoo.com with NNFMP; 18 Jul 2008 17:23:00 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 311454.99653.bm@omp112.mail.ac4.yahoo.com Received: (qmail 32473 invoked by uid 60001); 18 Jul 2008 17:23:00 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=THrq0DqGw4Sycd6VZFqvWcZuknXiDMOYZUSMdTYfjDLEqaxLsxPcZn0QzmQyMIudmqTzEktaJa0ZJFCzLmOuSyTNZc2xB4mYMkj65OppIuTKywRMPNJ+WiwhV95vFs1T+O3ig9JTG8HXDqulTZlK/RSAAsSDmJ4oWmF93ZH0HE8=; Received: from [209.88.228.11] by web59503.mail.ac4.yahoo.com via HTTP; Fri, 18 Jul 2008 10:22:59 PDT X-Mailer: YahooMailWebService/0.7.218 Date: Fri, 18 Jul 2008 10:22:59 -0700 (PDT) From: Lennin Caro Reply-To: lennin.caro@yahoo.com Subject: Re: long transaction To: pgsql-performance@postgresql.org, Sabin Coanda In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <120621.32315.qm@web59503.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.263 tagged_above=0 required=5 tests=AWL=0.263 X-Spam-Level: X-Archive-Number: 200807/154 X-Sequence-Number: 30754 have you use VACUMM? --- On Fri, 7/18/08, Sabin Coanda wrote: > From: Sabin Coanda > Subject: [PERFORM] long transaction > To: pgsql-performance@postgresql.org > Date: Friday, July 18, 2008, 3:34 PM > Hi there, > > I have a script which includes 30000 called functions > within a single > transaction. > > At the beginning, the functions runs fast enough (about 60 > ms each). In > time, it begins to run slower and slower (at final about > one per 2 seconds). > > I check the functions that runs slowly outside the script > and they run > normally (60 ms each). > > What is the problem ? > > TIA, > Sabin > > > > -- > Sent via pgsql-performance mailing list > (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance