pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Serge Dorofeev <sergeyd@ua.fm>
To: pgsql-performance@postgresql.org
Subject: How to force PostgreeSQL to work faster?
Date: Mon, 11 Aug 2003 11:59:45 +0300
Message-ID: <000101c35fe6$ea3fea80$3000a8c0@sergeyd> (raw)

Hi PostrgeSQL  team,

My PostrgeSQL installed as part of CYGWIN (Windows XP).
I have compared performance PostrgeSQL to MS SQL (I used a little Java
program with number of inserts in table).
MS SQL is faster in 12 times :-(
It's very strange results.
Guys who developed this server: what you can tell in this - what
customizations needs to increase of productivity?
How to force PostgreeSQL to work faster? 


 	 Speed (inserts/sec)	 Elapsed time (ms)	
MS SQL (Average):	 295	 39 869	
 	 testInsert 5000	  	
 	 263	 18 977	
 	 255	 19 619	
 	 306	 16 334	
 	  	  	
 	 testInsert 10000	  	
 	 315	 31 716	
 	 324	 30 905	
 	 319	 31 325	
 	  	  	
 	 testInsert 20000	  	
 	 241	 82 919	
 	 313	 63 922	
 	 317	 63 101	
 	  	  	
PostrgreSQL (Average):	 24	 520 160	
 	 testInsert 5000	  	
 	 26	 191 434	
 	 26	 191 264	
 	 26	 192 295	
 	  	  	
 	 testInsert 10000	  	
 	 22	 463 669	
 	 25	 393 510	
 	 24	 409 528	
 	  	  	
 	 testInsert 20000	  	
 	 24	 834 911	
 	 17	 1 184 613	
 	 24	 820 218	
MS SQL is faster (times):	 12	 13	



______________________________________________________
With regards,
Serge.

view thread (4+ messages)  latest in thread

Message-ID: <000101c35fe6$ea3fea80$3000a8c0@sergeyd>
Permalink:  ../000101c35fe6$ea3fea80$3000a8c0@sergeyd/
Also on:    postgresql.org/message-id/000101c35fe6$ea3fea80$3000a8c0@sergeyd

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: sergeyd@ua.fm
  Subject: Re: How to force PostgreeSQL to work faster?
  In-Reply-To: <000101c35fe6$ea3fea80$3000a8c0@sergeyd>
  References: <000101c35fe6$ea3fea80$3000a8c0@sergeyd>

* 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