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 5D70AD1D8AF for ; Mon, 24 Nov 2003 20:48:51 +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 31109-07 for ; Mon, 24 Nov 2003 16:48:24 -0400 (AST) Received: from natsmtp01.rzone.de (natsmtp01.rzone.de [81.169.145.166]) by svr1.postgresql.org (Postfix) with ESMTP id B59A9D1B531 for ; Mon, 24 Nov 2003 16:48:21 -0400 (AST) Received: from be-a-part.de (pD9E820FC.dip.t-dialin.net [217.232.32.252]) by post.webmailer.de (8.12.10/8.12.10) with ESMTP id hAOKmMMk010850 for ; Mon, 24 Nov 2003 21:48:22 +0100 (MET) Message-ID: <3FC26E96.9090101@be-a-part.de> Date: Mon, 24 Nov 2003 21:48:22 +0100 From: Torsten Schulz User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5b) Gecko/20030827 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Optimize Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/224 X-Sequence-Number: 4784 Yes, I know: very difficult question, but I don't know what to do now. Our Server: Dual-CPU with 1.2 GHz 1.5 GB RAM Our Problem: We are a Community. Between 19 and 21 o clock we have >350 User in the Community. But then, the Database are very slow. And we have per CPU ~20-30% idle-time. Has anyone an idea what's the best configuration for thta server? Many Greetings T. Schulz (with very bad english, i know)