"Nitesh" <[EMAIL PROTECTED]> wrote: > I'm using postgres as an backend with java servlet/jsp using linux as > operating system but when i see the see the CPU process using TOP command > than what i found that postmaster is using 97% of CPU which raise my system > speed very slow. so could u pls help me to sort out my problem that how can i > reduce the postmaster percentage.
Did you use enough shared memory ? Look on postgresql.conf the parameters sort_mem shared_buffer try to put there higher values. > Nitesh Jain > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly