From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeremy Haile <jhaile@fastmail.fm>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance of PostgreSQL on Windows vs Linux
Date: Thu, 04 Jan 2007 10:23:51 -0500
Message-ID: <17034.1167924231@sss.pgh.pa.us> (raw)
In-Reply-To: <1167922013.8482.283102539@webmail.messagingengine.com>
References: <1167845064.29222.282952329@webmail.messagingengine.com>
<459C39BF.4070403@hagander.net>
<1167922013.8482.283102539@webmail.messagingengine.com>
"Jeremy Haile" <jhaile@fastmail.fm> writes:
> Thanks for the response! I know I have to benchmark them to get a real
> answer. I am just looking to hear someone say "We benchmarked Linux vs.
> Windows with similar configuration and hardware and experienced a 25%
> performance boost in Linux." or "We benchmarked them and found no
> significant difference."
I've heard anecdotal reports both ways: "there's no difference" and
"there's a big difference". So there's no substitute for benchmarking
your own application.
I think one big variable in this is which PG version you are testing.
We've been gradually filing down some of the rough edges in the native
Windows port, so I'd expect that the performance gap is closing over
time. I don't know how close to closed it is in 8.2, but I'd surely
suggest that you do your benchmarking with 8.2.
regards, tom lane
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: tgl@sss.pgh.pa.us, jhaile@fastmail.fm
Subject: Re: Performance of PostgreSQL on Windows vs Linux
In-Reply-To: <17034.1167924231@sss.pgh.pa.us>
* 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