Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3DDD59FB2FC for ; Mon, 12 Mar 2007 12:00:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 04759-03 for ; Mon, 12 Mar 2007 12:00:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.242]) by postgresql.org (Postfix) with ESMTP id D4C5F9FB2EF for ; Mon, 12 Mar 2007 12:00:28 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so1323036ana for ; Mon, 12 Mar 2007 08:00:27 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=nhi3+y2lFpVgA4bUUdgBLbyKN8FXQL52t3uR24Rf3bK2RpVhkEs3rQFU7kUI88UlqjH5E3QxVG7F1WaKBQqtNlw7uX0vqX3VSjwTBskL1me0Dmfdb/mbJcIXNcB2Dnzfk8PwUkfh/+qiE+td0ZWATz0edtr+Ns7Pw/ZfZwTju9w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XcrH+d3qYEQA4iZW+GEwLKSS5UOomPrZXM0zXjUkWC+6hz/fvsD0oAlCeM7t3nQSomYh7znvWv5ZYOp/SeOQetWwT2Lze8gLlG8sF/rhm9PpFhRr0bM00Jwn/Q4Bmw6IwL6F3a4lo5YjwcGlbxSHPlERqOdHbX/AqlpBlV/7lp4= Received: by 10.114.89.1 with SMTP id m1mr1633000wab.1173711626648; Mon, 12 Mar 2007 08:00:26 -0700 (PDT) Received: by 10.114.12.15 with HTTP; Mon, 12 Mar 2007 08:00:26 -0700 (PDT) Message-ID: <7be3f35d0703120800kc3bbb99ub818fca7322ed161@mail.gmail.com> Date: Mon, 12 Mar 2007 16:00:26 +0100 From: "Harald Armin Massa" To: "Andreas Tille" Subject: Re: PostgreSQL in virtual machine Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/208 X-Sequence-Number: 23613 Andreas, I am responsible for some active PostgreSQL databases within virtual machines and on "plain metal"; all using Windows. There are spurious strange performance issues on those PostreSQL databases within the virtual machines. I can not pin them down (yet), and am not really able to blame them on vmware; but just want to recommend to be very very carefull about PostgreSQL in vmware and please communcate your findings. > 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 You did not specify the OS in your VM. I can report my experiences with W2k3 inside the VM: contrary to usual recommendations, smaller shared_buffers yielded better results. Growing effective_cache_size yielded the best results for me. Harald --=20 GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstra=DFe 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.