long transaction

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-performance(at)postgresql(dot)org
Subject: long transaction
Date: 2008-07-18 15:34:20
Message-ID: g5qd5o$1ot3$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steve Atkins 2008-07-18 15:41:04 Re: Mailing list hacked by spammer?
Previous Message Craig James 2008-07-18 15:02:37 Mailing list hacked by spammer?