have you use VACUMM? --- On Fri, 7/18/08, Sabin Coanda <[EMAIL PROTECTED]> wrote:
> From: Sabin Coanda <[EMAIL PROTECTED]> > 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
