X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 26B67D1D66C for ; Tue, 25 Nov 2003 02:25:18 +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 11223-08 for ; Mon, 24 Nov 2003 22:24:50 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 29F0BD1D880 for ; Mon, 24 Nov 2003 22:24:44 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id 3F394203A; Mon, 24 Nov 2003 21:24:47 -0500 (EST) To: Torsten Schulz Cc: pgsql-performance@postgresql.org Subject: Re: Optimize From: Neil Conway In-Reply-To: <3FC26E96.9090101@be-a-part.de> (Torsten Schulz's message of "Mon, 24 Nov 2003 21:48:22 +0100") References: <3FC26E96.9090101@be-a-part.de> Date: Mon, 24 Nov 2003 21:24:45 -0500 Message-ID: <87fzgdnq1e.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/233 X-Sequence-Number: 4793 Torsten Schulz writes: > Our Server: > Dual-CPU with 1.2 GHz > 1.5 GB RAM What kind of I/O subsystem is in this machine? This is an x86 machine, right? > Has anyone an idea what's the best configuration for thta server? It is difficult to say until you provide some information on the system's state during periods of heavy traffic. BTW, in addition to the machine's hardware configuration, have you looked at tuning the queries running on PostgreSQL? What about the OS kernel? -Neil