| 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: | Whole Thread | Raw Message | 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 |