pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Richard Huxton <dev@archonet.com>
To: dforums <dforums@vieonet.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Plz Heeeelp! performance settings
Date: Thu, 07 Aug 2008 16:08:52 +0100
Message-ID: <489B1004.4050105@archonet.com> (raw)
In-Reply-To: <489B06C0.3030305@vieonet.com>
References: <35FABCF85D99464FB00BC5123DC2A70A051D0FB8@s228130hz1ew09.apptix-01.savvis.net>
	<276541.4189.qm@web25805.mail.ukl.yahoo.com>
	<35FABCF85D99464FB00BC5123DC2A70A051D11E1@s228130hz1ew09.apptix-01.savvis.net>
	<48908988.7020204@emolecules.com>
	<Pine.LNX.4.64.0807301656020.4250@aragorn.flymine.org>
	<1217436578.6288.44.camel@localhost>
	<1240.1217440309@sss.pgh.pa.us>
	<1217441061.6288.47.camel@localhost>
	<489A21C2.8060801@vieonet.com>
	<b42b73150808061916j74fd5334y318ef3819fa49ea8@mail.gmail.com>
	<489AA5B5.9080109@vieonet.com>
	<489AB375.3090901@archonet.com>
	<489ABC8F.4030007@vieonet.com>
	<489AD118.5010902@archonet.com>
	<489AF8E8.6070503@vieonet.com>
	<489B02E6.4010701@archonet.com>
	<489B06C0.3030305@vieonet.com>

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

view thread (10+ messages)

Message-ID: <489B1004.4050105@archonet.com>
Permalink:  ../489B1004.4050105@archonet.com/
Also on:    postgresql.org/message-id/489B1004.4050105@archonet.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dev@archonet.com, dforums@vieonet.com
  Subject: Re: Plz Heeeelp! performance settings
  In-Reply-To: <489B1004.4050105@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox