X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id F163AD1B8A3 for ; Wed, 27 Aug 2003 03:53:18 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 14987-08 for ; Wed, 27 Aug 2003 03:52:49 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 7A064D1B550 for ; Wed, 27 Aug 2003 03:52:46 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h7R6uv8N012922 for ; Wed, 27 Aug 2003 12:26:57 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h7R6uuhi012896 for ; Wed, 27 Aug 2003 12:26:56 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Wed, 27 Aug 2003 12:24:40 +0530 MIME-Version: 1.0 Subject: Re: Sun vs a P2. Interesting results. Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F4CA308.15268.327E2C9@localhost> In-reply-to: X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/348 X-Sequence-Number: 3164 On 26 Aug 2003 at 8:34, Jeff wrote: > Could it just be that the sun sucks? (And for the record - same schema, > nearly same query (modified for datetime syntax) on informix runs in 3 > seconds). My impression is IPC on sun has higher initial latency than linux. But given that you also ran the tests with multiple connections and results were of similar pattern, I can't help to conclude that postgresql has to find a way to have faste IPC on solaris. I know I will be flamed for repeatedly making this suggestion. But what does tests with sparc linux on same machine yield? Bye Shridhar -- untold wealth, n.: What you left out on April 15th.