Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Steve AtkinsDate: 2008-07-18 15:41:04
Subject: Re: Mailing list hacked by spammer?
Previous:From: Craig JamesDate: 2008-07-18 15:02:37
Subject: Mailing list hacked by spammer?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group