Subject: Re: How to determine cause of performance problem?
From: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
To: Michael Stone <mstone+postgres@mathom.us>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <20050923110500.GX14918@mathom.us>
References: <1127458167.2475.105.camel@Panoramix>
	<20050923095517.GW14918@mathom.us> <1127470875.3524.17.camel@Panoramix>
	<20050923110500.GX14918@mathom.us>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: Fri, 23 Sep 2005 15:49:25 +0200
Message-Id: <1127483365.3524.36.camel@Panoramix>
Mime-Version: 1.0

On Fri, 2005-09-23 at 07:05 -0400, Michael Stone wrote: 
> On Fri, Sep 23, 2005 at 12:21:15PM +0200, Joost Kraaijeveld wrote:
> >On Fri, 2005-09-23 at 05:55 -0400, Michael Stone wrote:
> I didn't say it was, did I? 
No, you did not. But only last week someon'es head was (luckely for him
only virtually) almost chopped off for suggesting the usage of GUIDs ;-)


> Ok, that's great, but you didn't respond to the suggestion of using COPY
> INTO instead of INSERT.
Part of the code I left out are some data conversions (e.g. from
path-to-file to blob, from text to date (not castable because of the
homebrew original format)). I don't believe that I can do these in a SQL
statement, can I (my knowledge of SQL as a langage is not that good)? .
However I will investigate if I can do the conversion in two steps and
check if it is faster.

But still, I wonder if ~100 inserts/second is a reasonable performance
for my software/hardware combination.


-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl