X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 91B094758E6 for ; Fri, 7 Feb 2003 05:59:28 -0500 (EST) Received: from mail013.syd.optusnet.com.au (mail013.syd.optusnet.com.au [210.49.20.171]) by postgresql.org (Postfix) with ESMTP id 0959547595A for ; Fri, 7 Feb 2003 05:59:17 -0500 (EST) Received: from postgresql.org (adlax3-218.dialup.optusnet.com.au [198.142.82.218]) by mail013.syd.optusnet.com.au (8.11.1/8.11.1) with ESMTP id h17Ax0N19853; Fri, 7 Feb 2003 21:59:04 +1100 Message-ID: <3E439184.9020302@postgresql.org> Date: Fri, 07 Feb 2003 21:29:16 +1030 From: Justin Clift User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christian Toepp Cc: pgsql-performance@postgresql.org Subject: Re: postgres on solaris 8 References: <3E4389E7.80109@vhm.de> In-Reply-To: <3E4389E7.80109@vhm.de> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/33 X-Sequence-Number: 1089 Christian Toepp wrote: > hi, i have to set up a postgres database on a > sun enterprise 10000 machine running on solaris 8. > has anyone hints for tuning the database for me? Hi Chris, Sure. We need some info first: + How much memory is in the E10k? + What's the disk/array configuration of the E10k? + How many CPU's? (just out of curiosity) + Will the E10k be doing anything other than PostgreSQL? + Which version of PostgreSQL? (please say 7.3.2) + What is the expected workload of the E10k? Sorry for the not-entirely-easy questions, it's just that this will give us a good understanding of your configuration and what to recommend. Regards and best wishes, Justin Clift > regards > -Chris -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi