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
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 |