Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id D6BAD9FB433
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  1 Mar 2007 07:00:49 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 28443-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  1 Mar 2007 07:00:42 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
	by postgresql.org (Postfix) with ESMTP id 0333E9FB33A
	for <pgsql-performance@postgresql.org>;
	Thu,  1 Mar 2007 07:00:41 -0400 (AST)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 4B939308E2; Thu,  1 Mar 2007 12:00:40 +0100 (MET)
From: "Ben Trewern" <ben.trewern@mowlem.com>
X-Newsgroups: pgsql.performance
Subject: Re: performances with Pentium D
Date: Thu, 1 Mar 2007 11:00:38 -0000
Organization: Hub.Org Networking Services
Lines: 29
Message-ID: <es6bon$tb6$1@news.hub.org>
References: <1172678294.544317.195100@t69g2000cwt.googlegroups.com>
Reply-To: "Ben Trewern" <ben.trewern@mowlem.com>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
To: pgsql-performance@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50
X-Spam-Level: 
X-Archive-Number: 200703/104
X-Sequence-Number: 23509

I suspect the difference is your disk subsystem.  IDE disks (in your laptop 
I assume) quite often (almost always!!) ignore fsync calls and return as 
soon as the data gets to the disk cache, not the physical disk.  SCSI disks 
are almost always more correct, and wait until the data gets to the physical 
disk before they return from an fsync call.

I hope this helps.

Regards,

Ben
"hatman" <joel.winteregg@gmail.com> wrote in message 
news:1172678294.544317.195100@t69g2000cwt.googlegroups.com...
Hi all,

Do someone already had some problem with performances using a pentium
D (64 bits) and postgres 8.2.3 on a redhat enterprise update 2 ?
I did the install from sources and nothing change... I have a RAID 0
for data and 3Gb of RAM and my inserts rate is quite low, 8333 inserts/
sec (lower than on my laptop which is 10526 inserts/sec).
I suspect a problem with the CPU because using gkrellm, the use of 1
CPU is always quite low... Is it normal ?

Many thanks for your help,


Joël