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 E011311F670B for ; Mon, 3 Apr 2006 21:39:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54557-08 for ; Mon, 3 Apr 2006 21:39:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from my.endian.it (unknown [62.146.87.34]) by postgresql.org (Postfix) with ESMTP id 008A511F670D for ; Mon, 3 Apr 2006 21:39:39 -0300 (ADT) Received: from dell.home.lan (host163-44.pool8256.interbusiness.it [82.56.44.163]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id k341gMr23851; Tue, 4 Apr 2006 03:42:22 +0200 Subject: bad performance on Solaris 10 From: Chris Mair To: pgsql-performance@postgresql.org Content-Type: text/plain Date: Tue, 04 Apr 2006 02:39:38 +0200 Message-Id: <1144111178.3723.80.camel@dell.home.lan> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-22) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200604/36 X-Sequence-Number: 18120 Hi, I've got a somewhat puzzling performance problem here. I'm trying to do a few tests with PostgreSQL 8.1.3 under Solaris (an OS I'm sort of a newbie in). The machine is a X4100 and the OS is Solaris 10 1/06 fresh install according to manual. It's got two SAS disks in RAID 1, 4GB of RAM. Now the problem is: this box is *much* slower than I expect. I've got a libpg test program that happily inserts data using PQputCopyData(). It performs an order of magnitude worse than the same thing on a small Sun (Ultra20) running Linux. Or 4 times slower than an iBook (sic!) running MacOS X. So, I've this very bad feeling that there is something basic I'm missing here. Following are some stats: "sync; dd; sync" show these disks write at 53 MB/s => good. iostat 1 while my test is running says: tty sd0 sd1 sd2 sd5 cpu tin tout kps tps serv kps tps serv kps tps serv kps tps serv us sy wt id 1 57 0 0 0 0 0 0 0 0 0 1809 23 70 0 1 0 99 0 235 0 0 0 0 0 0 0 0 0 2186 223 14 1 1 0 99 0 81 0 0 0 0 0 0 0 0 0 2488 251 13 1 1 0 98 0 81 0 0 0 0 0 0 0 0 0 2296 232 15 1 0 0 99 0 81 0 0 0 0 0 0 0 0 0 2416 166 9 1 0 0 98 0 81 0 0 0 0 0 0 0 0 0 2528 218 14 1 1 0 99 0 81 0 0 0 0 0 0 0 0 0 2272 223 15 1 0 0 99 If I interpret this correctly the disk writes at not more than 2.5 MB/sec while the Opterons do nothing => this is bad. I've tried both, a hand compile with gcc and the solarispackages from pgfoundry.org => same result. Eons ago PCs had those "turbo" switches (it was never totally clear why they put them there in the first place, anyway). I've this bad feeling there's a secret "turbo" switch I can't spot hidden somewhere in Solaris :/ Bye, Chris.