	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

Postgres SQL Load Testing

Asked by bourneisp_ in PostgreSQL Database, Test / Validation Development Software

Tags: postgres sql load testing script how t

I currently have a web application which curretly runs off a back end database of pstgres ,
I lookng for ways to load test our queries and see if usage of certain functionality may caue load / cpu isses.

Ca anyone advie the best way i ca go about this.

E.g. New code/ report what happens if 200 people try to use this functionality all at the same time what impact does this have on our server.

View the Solution FREE for 30 Days

20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. suveer_p...30,513
2. MaduKp10,744
3. TheLearn...8,000
4. objects6,236
5. a_b6,220
6. jason11784,500
7. Christofer...4,200
8. CEHJ4,000
8. mas_oz...4,000
10. cdbosh3,200
11. pcelba2,672
12. ksivananth2,328
13. DarrenD2,000
13. angelIII2,000
13. hewittg2,000
13. tbsgadi2,000
13. graye2,000
13. rascalpants2,000
13. shalomc2,000
13. MASQUE...2,000
13. contactka...2,000
13. LSMCons...2,000
13. hazgoduk2,000
13. kaufmed2,000
13. MuraliKanth2,000
13. Qlemo2,000
13. rpnman2,000
13. lacrewga2,000
13. Ben_ocm2,000
13. psasik2,000
13. rdogmartin2,000
13. feridun2,000
13. jasonrmac2,000
13. Africans2,000
13. Zo3FoL2,000
13. leakim9712,000
13. douglashope2,000

1. suveer_p...30,513
2. MaduKp16,769
3. sunnycoder15,750
4. TheLearn...9,500
5. objects8,636
6. a_b6,220
7. CEHJ4,800
8. ksivananth4,528
9. jason11784,500
10. roos014,498
11. Christofer...4,200
12. mas_oz...4,000
13. jim_cakalic3,600
14. cdbosh3,200
15. paulop1...3,000
16. pcelba2,672
17. mplungjan2,500
17. graye2,500
17. PUNKY2,500
20. nobus2,400
21. LSMCons...2,150
22. ahoffmann2,000
22. DarrenD2,000
22. angelIII2,000
22. hewittg2,000
22. tbsgadi2,000
22. Dhaest2,000
22. rascalpants2,000
22. rionroc2,000
22. shalomc2,000
22. MASQUE...2,000
22. SGyves2,000
22. budchawla2,000
22. deroby2,000
22. contactka...2,000
22. hazgoduk2,000
22. exhaust2,000
22. JesterToo2,000
22. kaufmed2,000
22. MuraliKanth2,000
22. Qlemo2,000
22. rpnman2,000
22. realParker2,000
22. DaTribe2,000
22. lacrewga2,000
22. jackmcbarn2,000
22. marklorenz2,000
22. Ben_ocm2,000
22. HoggZilla2,000
22. psasik2,000
22. rdogmartin2,000
22. feridun2,000
22. jasonrmac2,000
22. Africans2,000
22. Zo3FoL2,000
22. leakim9712,000
22. douglashope2,000