postmaster problem....
postmaster problem....
От:
Nitesh <niteshj@ebotsoft.com>
Дата:
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. Nitesh Jain
Re: postmaster problem....
От:
"Gaetano Mendola" <mendola@bigfoot.com>
Дата:
"Nitesh" 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 majordomo@postgresql.org)