Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Postgres performance failing under load

Status
Not open for further replies.

dwaldrop

Programmer
Jan 23, 2006
1
US
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!

 
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
Optimising
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top