Re: CPU killer

* Vilson farias <vilson(dot)farias(at)digitro(dot)com(dot)br> [001027 21:38] wrote:
> Greetings,
>
> I've been using Postgres in a Pentium 75Mhz, Linux RedHat 6.2, 32Mb.
>
> Every big query I execute uses too much cpu (more than 90%).
>
> I start postgres with these params: su -l postgres -c
> '/usr/bin/postmaster -B 2048 -i -D "/home/postgres/data"' &.
>
> What should I do for avoid postgres extreme cpu allocation? I know sometimes
> non-indexed tables or huge size tables can be slow, but here I don't care
> about execution speed, I just want less cpu allocation no matter how slow.

Unix is a timesharing system, if you want an application on unix
to use less CPU then put it on a box with a slower CPU. If you
want to limit its priority against other processes so that it
shares CPU in a more friendly manner, then you want to read the
manpage for nice(1).

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."