Re: Plz Heeeelp! performance settings - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Plz Heeeelp! performance settings
Date
Msg-id 489B1004.4050105@archonet.com
Whole thread Raw
In response to Database size Vs performance degradation  ("Dave North" <DNorth@signiant.com>)
List 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

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Plz Heeeelp! performance settings
Next
From: "Joshua Shanks"
Date:
Subject: Re: query planner not using the correct index