On Nov 16, 2007 11:59 AM, <xeb@mail.ru> wrote:
> Hello!
> Process postmaster completly eat my proccessor for a long time and i see that
> message in logs.
> Does anybody know what does the subj means and why it occures ?
You're giving us WAY too little information to troubleshoot this problem.
What message in the logs? What does top / vmstat / ps / iostat really
show? What kind of query is running? Have you got query logging
turned on for long running queries? Is this actually affecting the
performance of your machine? Is the process chewing through all your
memory? If you know what query is causing this, what does explain
analyze of the query look like?
The more info you can provide about the issue, the more we can help.
But first we have to be sure there's a problem.
If you're asking postgresql to sort 1billion rows it is going to eat
up a lot of CPU and there's little you can do about it.