Обсуждение: postmaster problem....

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

"Nitesh" <niteshj@ebotsoft.com> 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)