Re: priority on a process

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> I have a process running and it seems that it is not
> using very much of the available resources on the server

> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND

> postgres 11467 3.4 0.3 8204 3176 ? D 07:58 12:02 postgres:
> charles testdb [local] UPDATE

It's waiting for disk I/O --- that's what the D means.

> Q2: why will some jobs hog system resouces and others,
> like this one, won't do much of anything?

You have too narrow a view of what system resources are ;-). I feel
sure that this query is banging the heck out of your disk. When the
disk is the bottleneck, worrying about improving CPU usage is pointless.

regards, tom lane