problem, although autovacuum is set.
However I checked the following scenario to find a solution. I call the
30000 statements without transaction. The performance it not changed. But
when I add VACUUM command after each 20 statement set, I got the linear
performance that I want. Unfortunatelly this is not possible inside a
Do you know how could I solve my problem, keeping the 30000 statements
inside a single transaction ?
"Lennin Caro" <firstname.lastname@example.org> wrote in message
> have you use VACUMM?
> --- On Fri, 7/18/08, Sabin Coanda <email@example.com> wrote:
>> From: Sabin Coanda <firstname.lastname@example.org>
>> Subject: [PERFORM] long transaction
>> To: email@example.com
>> Date: Friday, July 18, 2008, 3:34 PM
>> Hi there,
>> I have a script which includes 30000 called functions
>> within a single
>> 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 ?
>> Sent via pgsql-performance mailing list
>> To make changes to your subscription:
> Sent via pgsql-performance mailing list (firstname.lastname@example.org)
> To make changes to your subscription:
Sent via pgsql-performance mailing list (email@example.com)
To make changes to your subscription: