From: Greg Stark <gsstark@mit.edu>
To: Vitaly Belman <vitalib@012.net.il>
Cc: pgsql-performance@postgresql.org, Bryan Encina <bryan.encina@valleypres.org>
Cc: Matthew Nuzum <cobalt@bearfruit.org>
Subject: Re: PostgreSQL on VMWare vs Windows vs CoLinux
Date: 02 Jun 2004 10:27:36 -0400
Message-ID: <87n03m592f.fsf@stark.xeocode.com> (raw)
In-Reply-To: <16113857921.20040602015607@012.net.il>
References: <16113857921.20040602015607@012.net.il>
Vitaly Belman <vitalib@012.net.il> writes:
> With all that said, VMWare is badly suited for running a database,
> while CoLinux can be run as a service (didn't try it yet though),
> VMWare always sits there, it is slow to go up, slow to go down and
> generally feels like a system hog.
Uhm, it sounds like you're using VMWare Workstation? VMWare has a range of
different versions including some that are specifically targeted towards
server situations. I think they had the idea that hosting companies would run
hundreds of virtual machines on a server and provide their hosting clients
with a virtual machine to play with.
That said, I'm curious why the emulated servers performed better than the
Native Windows port. My first thought is that they probably aren't syncing
every write to disk so effectively they're defeating the fsyncs, allowing the
host OS to buffer disk writes.
I would be curious to see better stats on things like a pgbench run which
would give some idea of the context switch efficiency, and a large select or
update, which would give some idea of the i/o throughput. Really there's no
excuse for the Windows port to be slower than an emulator. Barring effects
like the disk caching I mentioned, it should far outpace the emulators.
--
greg
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsstark@mit.edu, vitalib@012.net.il, bryan.encina@valleypres.org, cobalt@bearfruit.org
Subject: Re: PostgreSQL on VMWare vs Windows vs CoLinux
In-Reply-To: <87n03m592f.fsf@stark.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox