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)

FAQ