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

Re: long transaction

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org, Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Subject: Re: long transaction
Date: 2008-07-18 17:22:59
Message-ID: 120621.32315.qm@web59503.mail.ac4.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
have you use VACUMM?

--- On Fri, 7/18/08, Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro> wrote:

> From: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
> Subject: [PERFORM] long transaction
> To: pgsql-performance(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance


      


In response to

Responses

pgsql-performance by date

Next:From: Craig JamesDate: 2008-07-18 17:40:33
Subject: Re: Mailing list hacked by spammer?
Previous:From: Glyn AstillDate: 2008-07-18 16:37:54
Subject: Re: Mailing list hacked by spammer?

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