From: Sabin Coanda <sabin.coanda@deuromedia.ro>
To: pgsql-performance@postgresql.org
Subject: Re: long transaction
Date: Mon, 11 Aug 2008 09:53:07 +0300
Message-ID: <g7onk7$12sj$1@news.hub.org> (raw)
References: <g5qd5o$1ot3$1@news.hub.org>
<120621.32315.qm@web59503.mail.ac4.yahoo.com>
No, I cannot use VACUUM inside the transaction, and it seems this is the
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
transaction.
Do you know how could I solve my problem, keeping the 30000 statements
inside a single transaction ?
Sabin
"Lennin Caro" <lennin.caro@yahoo.com> wrote in message
news:120621.32315.qm@web59503.mail.ac4.yahoo.com...
> 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
>
>
>
>
>
> --
> 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: sabin.coanda@deuromedia.ro
Subject: Re: long transaction
In-Reply-To: <g7onk7$12sj$1@news.hub.org>
* 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