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

Re: How to optimize insert statements ?

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Christian Leclerc <cleclerc(at)ilog(dot)fr>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-novice(at)postgresql(dot)org
Subject: Re: How to optimize insert statements ?
Date: 2007-07-25 11:03:40
Message-ID: 46A72E0C.9060000@mail.nih.gov (view raw or flat)
Thread:
Lists: pgsql-novice
Christian Leclerc wrote:
> Hello Tom,
>
> Thanks for your reply and advise. I understand in your email that the
> use of a sequence object will increase the performance of my trigger.
> Therefore I'm going to replace that in my code immediately. Anyway, my
> problem is not exactly the performances; it's more the insertion time
> growing. Indeed I don't understand why the insertion time grows
> "exponentially" with my single transaction. If I split my objects
> insertion into several transactions (instead of one), the problem seems
> to disappear. Would you see any reasons linked to the Postgres
> transactions explaining this insertion time growing ?   
>   
I think that the insertion time growing is related to the way in which 
you were doing your inserts; using a sequence object will likely fix the 
issue and then you will have the answer to your question.

Sean

In response to

Responses

pgsql-novice by date

Next:From: Christian LeclercDate: 2007-07-25 17:40:14
Subject: Re: How to optimize insert statements ?
Previous:From: Christian LeclercDate: 2007-07-25 10:48:17
Subject: Re: How to optimize insert statements ?

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