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 30D243A461C for ; Thu, 20 Jan 2005 04:04:34 +0000 (GMT) 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 10723-01 for ; Thu, 20 Jan 2005 04:04:29 +0000 (GMT) Received: from planae.com.br (nat.planae.com.br [200.210.129.190]) by svr1.postgresql.org (Postfix) with SMTP id 2DDEB3A4603 for ; Thu, 20 Jan 2005 04:04:27 +0000 (GMT) Received: (qmail 43686 invoked by uid 1004); 20 Jan 2005 04:05:27 -0000 Received: from 127.0.0.1 by mercurio.planae.com.br (envelope-from , uid 0) with qmail-scanner-1.23 (clamdscan: 0.75. uvscan: v4.3.20/v4420. Clear:RC:1(127.0.0.1):. Processed in 0.703688 secs); 20 Jan 2005 04:05:27 -0000 Received: from localhost (HELO webmail.planae.com.br) (127.0.0.1) by localhost with SMTP; 20 Jan 2005 04:05:26 -0000 Received: from 10.20.2.231 (SquirrelMail authenticated user gfnobrega@planae.com.br); by webmail.planae.com.br with HTTP; Thu, 20 Jan 2005 02:05:26 -0200 (BRST) Message-ID: <1892.10.20.2.231.1106193926.squirrel@10.20.2.231> Date: Thu, 20 Jan 2005 02:05:26 -0200 (BRST) Subject: Tips and tunning for pgsql on HP-UX PA-RISC (RP3410) From: Gustavo Franklin =?iso-8859-1?Q?N=F3brega?= To: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/255 X-Sequence-Number: 9945 Hi, Anyone have tips for performance of Postgresql, running on HP-UX 11.11, PA-RISC (HP RP3410)? What is better compiler (GCC or HP C/ANSI), flags of compilation, kernel and FS tunning? I have installed pgsql, and compiled with gcc -O2 -fexpensive-optimizations flags only. Another question: Postgres running well on HP-UX? What is the better: HP-UX or Linux on HP RP3410? Thanks! Gustavo Franklin Nóbrega Infraestrutura e Banco de Dados Planae Tecnologia da Informação (+55) 14 3224-3066 Ramal 209 www.planae.com.br