X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AA993329E94 for ; Sat, 18 Sep 2004 18:03:06 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67766-07 for ; Sat, 18 Sep 2004 17:03:01 +0000 (GMT) Received: from latenight.fiasco.org.il (latenight.fiasco.org.il [192.117.122.39]) by svr1.postgresql.org (Postfix) with SMTP id A066F329E8C for ; Sat, 18 Sep 2004 18:02:56 +0100 (BST) Received: (qmail 15132 invoked from network); 18 Sep 2004 17:02:53 -0000 Received: from unknown (HELO ?172.16.19.91?) (192.117.102.130) by latenight.fiasco.org.il with SMTP; 18 Sep 2004 17:02:49 -0000 Message-ID: <414C6A38.1060800@shemesh.biz> Date: Sat, 18 Sep 2004 20:02:48 +0300 From: Shachar Shemesh Organization: Lingnu Open Source Consulting ltd. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040820 Debian/1.7.2-4 X-Accept-Language: en MIME-Version: 1.0 To: ischamay.andbergsay@activestateway.com Cc: pgsql-performance@postgresql.org Subject: Re: Tryint to match Solaris-Oracle performance with directio? References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/195 X-Sequence-Number: 8323 Mischa Sandberg wrote: > In the meantime, what I gather from browsing mail archives is that > postgresql on Solaris seems to get hung up on IO rather than CPU. Well, people more knowledgeable in the secrets of postgres seem confident that this is not your problem. Fortunetly, however, there is a simple way to find out. Just download the utinyint var type from pgfoundry (http://pgfoundry.org/projects/sql2pg/). There are some stuff there you will need to compile yourself from CVS. I'm sorry, but I haven't done a proper release just yet. In any case, the utinyint type should provide you with the data type you seek, and thus allow you to find out whether this is, indeed, the problem. -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/