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

Re: performance error

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: <Tom(dot)Zschockelt(at)flender(dot)com>,<pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: performance error
Date: 2004-03-31 11:47:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers-win32
First of all, anything that is insert-only is certainly to be I/O bound,
and not CPU bound, so it really doesn't surprise me that much. Also, you
will normally get drastically better performance if you wrap the INSERT
statements in a transaction.
Finally, remember that the win32 port is very much under development.
There are certainly several points where it can be perfromance
optimised, but we're not quite there yet.
An interesting thing might also be a comparison between this and a
straight libpq program. I have no idea what the overheard of the ODBC
driver is. I doubt it's something you'd noticei n this scenario, but
it's not totally impossible.

	-----Original Message-----
	From: Tom(dot)Zschockelt(at)flender(dot)com
	Sent: Wednesday, March 31, 2004 1:01 PM
	To: pgsql-hackers-win32(at)postgresql(dot)org
	Subject: [pgsql-hackers-win32] performance error

	Hi to all, 
	I downloaded the last win32-snapshot and got it all in a ready
	After that I created a simple testtable like 
	CREATE TABLE public.testdaten1 
	 id int4 NOT NULL, 
	 name varchar(20), 
	 firstname varchar(20), 
	 CONSTRAINT testdaten1_pkey PRIMARY KEY (id) 
	GRANT ALL ON TABLE public.testdaten1 TO public; 
	Now I tested a simple c++ program which, do many inserts within
a for-loop (connected over ODBC) 
	I'm not sure but I think the performance is not very well (it's
really bad) 
	cpu-usage between 0 and 5 %
	harddisc is permanently busy but the inserting-process is very
slow (50000 records in 30 minutes) 
	Are there any ideas to get rid of this problem ?
	Regards tom

pgsql-hackers-win32 by date

Next:From: David FloryDate: 2004-04-01 04:48:40
Subject: How to shutdown PostgreSQL in WinXP
Previous:From: Tom.ZschockeltDate: 2004-03-31 11:01:19
Subject: performance error

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