pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shachar Shemesh <psql@shemesh.biz>
To: Greg Stark <gsstark@mit.edu>
Cc: 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: Wed, 02 Jun 2004 23:24:19 +0300
Message-ID: <40BE3773.1000107@shemesh.biz> (raw)
In-Reply-To: <87n03m592f.fsf@stark.xeocode.com>
References: <16113857921.20040602015607@012.net.il>
	<87n03m592f.fsf@stark.xeocode.com>

Greg Stark wrote:

>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 havn't tested it, and it's certanly possible. However, please bear in 
mind that it is also possible that it just gives better performance.

The reason this may be possible is that the emulation layer gets the CPU 
(and other resources) from the OS in bulk, and decides on it's own how 
to allocate it to the various processes running within the emulation. 
Inparticular, this "on it's own" is done using the stock Linux kernel. 
As Postgresql works sufficiently better on Linux than on Windows, this 
yields better performance.

Again - speculation only. Someone should defenitely make sure that no 
caching takes place where it shouldn't.

As a side note, I have had a chance to talk to Dan Aloni (coLinux 
maintainer) about running PostgreSQL on coLinux. He said that he knows 
that this particular use is high on people's priority list, but he feels 
it is totally unsafe to run a production database on alpha grade 
software. Then again, free software projects being what they are, this 
is usually what a maintainer would say.

             Shachar

-- 
Shachar Shemesh
Lingnu Open Source Consulting
http://www.lingnu.com/




view thread (13+ messages)  latest in thread

Message-ID: <40BE3773.1000107@shemesh.biz>
Permalink:  ../40BE3773.1000107@shemesh.biz/
Also on:    postgresql.org/message-id/40BE3773.1000107@shemesh.biz

 · 

reply

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: psql@shemesh.biz, 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: <40BE3773.1000107@shemesh.biz>

* 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