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