X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 84BD39DC8DE
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 21 Mar 2006 10:34:50 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 88065-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 21 Mar 2006 10:34:54 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.mnc.ch (62-2-77-205.business.cablecom.ch [62.2.77.205])
	by postgresql.org (Postfix) with ESMTP id 09DAB9DC82D
	for <pgsql-performance@postgresql.org>;
	Tue, 21 Mar 2006 10:34:47 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by mail.mnc.ch (Postfix) with ESMTP id 6235EA8319;
	Tue, 21 Mar 2006 15:35:01 +0100 (CET)
Received: from mail.mnc.ch ([127.0.0.1])
	by localhost (mail.test.lan [127.0.0.1]) (amavisd-new,
	port 10025) with ESMTP
	id 16241-04; Tue, 21 Mar 2006 15:35:01 +0100 (CET)
Received: from meuh.mnc.lan (62-2-77-204.business.cablecom.ch [62.2.77.204])
	by mail.mnc.ch (Postfix) with ESMTP id 02D79A82B2;
	Tue, 21 Mar 2006 15:35:01 +0100 (CET)
Received: by meuh.mnc.lan (Postfix, from userid 1000)
	id B279C183669; Tue, 21 Mar 2006 15:34:48 +0100 (CET)
To: Edoardo Serra <osdevel@webrainstorm.it>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postmaster using only 4-5% CPU
References: <7.0.0.16.2.20060321115738.060f9078@webrainstorm.it>
X-Hashcash: 
 1:20:060321:osdevel@webrainstorm.it::AdVdnpyo+nEDgzIA:000000000000000000000000000000000000003FDC
X-Hashcash: 
 1:20:060321:pgsql-performance@postgresql.org::EtSvC7hnGFqDUDAK:000000000000000000000000000003zyW
From: Guillaume Cottenceau <gc@mnc.ch>
Date: 21 Mar 2006 15:34:48 +0100
In-Reply-To: <7.0.0.16.2.20060321115738.060f9078@webrainstorm.it>
Message-ID: <87slpbkgs7.fsf@meuh.mnc.lan>
Lines: 34
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.4
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: amavisd-new at mnc.ch
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.103 required=5 tests=[AWL=0.103]
X-Spam-Score: 0.103
X-Spam-Level: 
X-Archive-Number: 200603/405
X-Sequence-Number: 17842

Edoardo Serra <osdevel 'at' webrainstorm.it> writes:

> Hi all,
>          I'm having a very strange performance problems on a fresh
> install of postgres 8.1.3
> I've just installed it with default option and --enable-thread-safety
> without tweaking config files yet.
> 
> The import of a small SQL files into the DB (6 tables with 166.500
> total records, INSERT syntax)
> took me more than 18 minutes as shown below (output of  "time ./psql
> benchmarks < dump.sql")
> 
> real 18m33.062s
> user 0m10.386s
> sys 0m7.707s
> 
> The server is an
> - Intel(R) Xeon(TM) CPU 3.60GHz - 1MB L2
> - 1 GB RAM
> - 2x HDD SCSI U320 RAID 1 Hardware (HP 6i controller)

I have seen similar very low performance for INSERTs, although
using SCSI 320 disk, controlled by LSI Logic 53C1030 (using
Fusion MPT SCSI Host driver 3.01.18 on Linux 2.6.11). Something
like tens of INSERTs per second into a small table, no more.
"iostat" reports very large figures in the "await" field compared
to other servers using raid1 controllers, that's my best guess,
but I was unable to find why and how to fix (and the vendor has
been very helpless until now). I'm wondering if we don't have an
issue with the driver but have no more clue.

-- 
Guillaume Cottenceau