* Vilson farias <vilson.farias@digitro.com.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@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."
