Postgres performance failing under load

[dwaldrop]

I am working on an application that has just begun supporting Postgres. We have been working with MySQL for several years. The application is in PHP (5.1) using PEAR and running under IIS on Windows Server 2003.

When running with one user, Postgres is about 50% faster than MySQL. However, when we run our loadtesting scripts, the Postgres version continually fails early in the test.

When the failures occur, the event log reports :

Failing application w3wp.exe version 6.0.3790.1830, faulting module msvcrt.dll, version 7.0.3790.1830, fault address 0x00026f76.

Has anyone else experienced such a scenario? I appreciate any suggestions.

Thank you!

 

[ceco]

I haven't used postgresql on windows, but i have heard that 8.1 is much better than 8.0

which version do you use

for performance tuning see this page

http://techdocs.postgresql.org/

Optimising