From: Lennin Caro <lennin.caro@yahoo.com>
To: pgsql-performance@postgresql.org, Sabin Coanda <sabin.coanda@deuromedia.ro>
Subject: Re: long transaction
Date: Fri, 18 Jul 2008 10:22:59 -0700 (PDT)
Message-ID: <120621.32315.qm@web59503.mail.ac4.yahoo.com> (raw)
In-Reply-To: <g5qd5o$1ot3$1@news.hub.org>
have you use VACUMM?
--- On Fri, 7/18/08, Sabin Coanda <sabin.coanda@deuromedia.ro> wrote:
> From: Sabin Coanda <sabin.coanda@deuromedia.ro>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lennin.caro@yahoo.com, sabin.coanda@deuromedia.ro
Subject: Re: long transaction
In-Reply-To: <120621.32315.qm@web59503.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox