Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 47F0F9FB416 for ; Mon, 12 Mar 2007 05:47:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 77965-10 for ; Mon, 12 Mar 2007 05:47:33 -0300 (ADT) X-Greylist: delayed 00:22:44.292363 by SQLgrey-1.7.4 Received: from fw-bonn.bund.de (mail4-bonn.bund.de [194.95.179.140]) by postgresql.org (Postfix) with ESMTP id D8FC79FB409 for ; Mon, 12 Mar 2007 05:47:35 -0300 (ADT) Received: from m4.mfw.bn.ivbb.bund.de (localhost [127.0.0.1]) by fw-bonn.bund.de (8.13.8/8.13.8) with ESMTP id l2C8Qdqd018095 for ; Mon, 12 Mar 2007 09:26:39 +0100 (CET) Received: (from localhost) by m4.mfw.bn.ivbb.bund.de (MSCAN) id 3/m4.mfw.bn.ivbb.bund.de/smtp-gw/mscan; Mon Mar 12 09:26:39 2007 Date: Mon, 12 Mar 2007 09:24:45 +0100 (CET) From: Andreas Tille X-X-Sender: tillea@wr-linux02 To: pgsql-performance@postgresql.org Subject: PostgreSQL in virtual machine Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-OriginalArrivalTime: 12 Mar 2007 08:25:22.0321 (UTC) FILETIME=[FA1D8010:01C7647F] X-TM-AS-Product-Ver: SMEX-7.0.0.1499-3.6.1039-15044.001 X-TM-AS-Result: No-2.806600-8.000000-31 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.052 tagged_above=0 required=5 tests=AWL, BAYES_50, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200703/207 X-Sequence-Number: 23612 Hi, I'm running a Zope web application that obtains most of its data from a PostgreSQL 8.1 database in a virtual machine. I'm able to adjust the memory of this machine according to reasonable values and can choose between one or two (emulated) processors. The question is: How can I find an optimal relation between the virtual hardware parameters and PostgreSQL performance. I guess it makes no sense to blindly increase virtual memory without adjusting PostgreSQL configuration. Are there any experiences about reasonable performance increasing strategies? Are there any special things to regard in a VM? Kind regards Andreas. -- http://fam-tille.de