X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D5B4ED1D2A4; Tue, 23 Mar 2004 05:38:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 64682-06; Tue, 23 Mar 2004 01:38:12 -0400 (AST) Received: from linda-2.paradise.net.nz (bm-2a.paradise.net.nz [202.0.58.21]) by svr1.postgresql.org (Postfix) with ESMTP id 73D1FD1CC7F; Tue, 23 Mar 2004 01:38:11 -0400 (AST) Received: from smtp-2.paradise.net.nz (smtp-2b.paradise.net.nz [202.0.32.211]) by linda-2.paradise.net.nz (Paradise.net.nz) with ESMTP id <0HV000J58KZLGU@linda-2.paradise.net.nz>; Tue, 23 Mar 2004 17:38:10 +1200 (NZST) Received: from paradise.net.nz (203-96-145-196.adsl.paradise.net.nz [203.96.145.196]) by smtp-2.paradise.net.nz (Postfix) with ESMTP id 17D299E657; Tue, 23 Mar 2004 17:38:09 +1200 (NZST) Date: Tue, 23 Mar 2004 17:39:38 +1200 From: Mark Kirkwood Subject: Re: [PERFORM] Benchmarking postgres on Solaris/Linux In-reply-to: To: "Subbiah, Stalin" Cc: "'pgsql-performance@postgresql.org'" , "'pgsql-admin@postgresql.org'" Message-id: <405FCD9A.2010207@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.5) Gecko/20031213 References: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/339 X-Sequence-Number: 12908 The hardware platform to deploy onto may well influence your choice : Intel is usually the most cost effective , which means using Linux makes sense in that case (anybody measured Pg performance on Solaris/Intel....?). If however, you are going to run a very "big in some sense" database, then 64 bit hardware is desirable and you can look at the Sun offerings. In this case you can run either Linux or Solaris (some informal benchmarks suggest that for small numbers of cpus, Linux is probably faster). It might be worth considering Apple if you want a 64-bit chip that has a clock speed comparable to Intel's - the Xserv is similarly priced to Sun V210 (both dual cpu 1U's). Are you free to choose any hardware? best wishes Mark Subbiah, Stalin wrote: >(snipped) what is the preferred OS >for postgres deployment if given an option between linux and solaris. > > >