performance issues on windows with 8.3.0?

From: "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: performance issues on windows with 8.3.0?
Date: 2008-02-14 02:06:55
Message-ID: 82f04dc40802131806v70044b1cuca28c288f7b4e8ba@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Are there any known regression issues WRT performance on the 8.3.0.1
binary build for windows?

And I mean serious -multiple orders of magnitude- performance issues
running simple queries on a small database...

A little more background. I built 8.3.0 on Cent OS 5 today. Started
using it with a server application that I have to do some
benchmarking. Java application connecting via jdbc to Postgres on
localhost. Everything looked great. Perhaps even faster than 8.2 -
but I don't have the benchmarks to say for sure yet.

Then, I wanted to test what is usually our fastest performing setup -
with the database on a second system. So, I installed the new 8.3 on
a Windows 2003 system, started it up, created my database, pointed my
java app to it and everything seemed good.

Then I put a load on it - and my server thru-put went from about 1500
messages per second on the linux-localhost combination to 30 on the
remote windows postgres installation.

I will be investigating this much more completely first thing tomorrow
- but I figured I'd ask to see if there was something obvious first...

Thanks,

Dan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-02-14 04:03:31 Re: pg_dump, pg_restore.
Previous Message Decibel! 2008-02-14 01:56:04 Re: Some Autovacuum Questions