Re: Plz Heeeelp! performance settings

From: Richard Huxton <dev(at)archonet(dot)com>
To: dforums <dforums(at)vieonet(dot)com>
Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Plz Heeeelp! performance settings
Date: 2008-08-07 15:08:52
Message-ID: 489B1004.4050105@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

dforums wrote:
> The delete is global, the procedure is called for each line/tracks.
> > So - are you calling this function 14000 times to inject your data?
> > You're doing this in one transaction, yes?
> NO I have to make it 14000 times cause, I use some inserted information
> for other insert to make links between data.

Why does that stop you putting all 14000 calls in one transaction?

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua Shanks 2008-08-07 15:11:43 Re: query planner not using the correct index
Previous Message Merlin Moncure 2008-08-07 15:05:30 Re: Plz Heeeelp! performance settings