Amrit, can you post explain <your slow update query> so we can see what it does ? Dave [EMAIL PROTECTED] wrote: Today is the first official day of this weeks and the system run better in serveral points but there are still some points that need to be corrected. Some queries or some tables are very slow. I think the queries inside the programe need to be rewrite. Now I put the sort mem to a little bit bigger: sort mem = 16384 increase the sort mem makes no effect on the slow point eventhough there is little connnection. shared_buffers = 27853 effective cache = 120000If I were you I would upgrade from RH 9 to Fedora Core 2 or 3 after some initial testing. You'll see a huge improvement of speed on the system as a whole. I would try turning hyperthreading off also.Now I turn hyperthreading off and readjust the conf . I found the bulb query that was : update one flag of the table [8 million records which I think not too much] .When I turned this query off everything went fine. I don't know whether update the data is much slower than insert [Postgresql 7.3.2] and how could we improve the update method? Thanks for many helps. Amrit Thailand NB. I would like to give my appreciation to all of the volunteers from many countries who combat with big disaster [Tsunamies] in my country [Thailand]. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend -- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561 |
- Re: [PERFORM] Low Performance for big hospital server .. Dave Cramer
- Re: [PERFORM] Low Performance for big hospital server ... William Yu
- Re: [PERFORM] Low Performance for big hospital server ... Dawid Kuroczko
- Re: [PERFORM] Low Performance for big hospital ser... amrit
- Re: [PERFORM] Low Performance for big hospital ser... Josh Berkus
- Re: [PERFORM] Low Performance for big hospital... Frank Wiles
- Re: [PERFORM] Low Performance for big hosp... Dave Cramer
- Re: [PERFORM] Low Performance for big... Rod Taylor
- Re: [PERFORM] Low Performance for... Yann Michel
- Re: [PERFORM] Denormalization WAS: Low Per... Josh Berkus
- Re: [PERFORM] Denormalization WAS: Lo... Frank Wiles