Re: long transaction

have you use VACUMM?

--- On Fri, 7/18/08, Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro> wrote:

> From: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
> Subject: [PERFORM] long transaction
> To: pgsql-performance(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance