Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 94A189FB956 for ; Tue, 13 Mar 2007 17:23:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 81036-07 for ; Tue, 13 Mar 2007 17:23:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp-out3.libero.it (smtp-out3.libero.it [212.52.84.43]) by postgresql.org (Postfix) with ESMTP id 9472D9FB6B1 for ; Tue, 13 Mar 2007 17:23:47 -0300 (ADT) Received: from localhost (172.31.0.47) by smtp-out3.libero.it (7.3.120) id 45D9985C01928FE3 for pgsql-performance@postgresql.org; Tue, 13 Mar 2007 21:23:46 +0100 X-Scanned: with antispam and antivirus automated system at libero.it Received: from smtp-out3.libero.it ([172.31.0.39]) by localhost (asav-out6.libero.it [192.168.32.34]) (amavisd-new, port 10024) with ESMTP id Hew7dlDC1Y7C for ; Tue, 13 Mar 2007 21:23:46 +0100 (CET) Received: from [151.25.102.196] (151.25.102.196) by smtp-out3.libero.it (7.3.120) id 45D9987101D48D4A for pgsql-performance@postgresql.org; Tue, 13 Mar 2007 21:23:46 +0100 Message-ID: <45F70815.5080100@streppone.it> Date: Tue, 13 Mar 2007 21:22:45 +0100 From: Cosimo Streppone User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: it, it-it, en-us, en MIME-Version: 1.0 To: Postgresql Performance list Subject: Re: PostgreSQL in virtual machine References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.409 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: * X-Archive-Number: 200703/237 X-Sequence-Number: 23642 Andreas Tille wrote: > Are there any experiences > about reasonable performance increasing strategies? Are there any > special things to regard in a VM? Not directly about Postgresql, but I'm seeing evidence that upgrading from vmware 2.5.3 to 3.0.1 seems to have solved disk access performance issues (measured with simple dd runs). With vmware 2.5.3 + RedHat Enterprise 4.0 I measured a sequential read performance on 1-2 Gb files of less than 10 Mbytes/sec on a IBM FastT600 SAN volume partition. After the upgrade to 3.0 I had feedback from sysadmins that issue was solved, but I didn't have the opportunity to repeat the read tests yet. -- Cosimo