long transaction - Mailing list pgsql-performance

From Sabin Coanda
Subject long transaction
Date
Msg-id g5qd5o$1ot3$1@news.hub.org
Whole thread Raw
Responses Re: long transaction  (Lennin Caro <lennin.caro@yahoo.com>)
List pgsql-performance
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



pgsql-performance by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Mailing list hacked by spammer?
Next
From: Alvaro Herrera
Date:
Subject: Re: Mailing list hacked by spammer?