Re: [GENERAL] CPU killer

2000-10-27 Thread Tod McQuillin
On Fri, 27 Oct 2000, Vilson farias wrote: > 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/post

Re: [GENERAL] CPU killer

2000-10-27 Thread Igor Roboul
On Fri, Oct 27, 2000 at 07:12:57PM -0200, Vilson farias wrote: >I start postgres with these params: su -l postgres -c > '/usr/bin/postmaster -B 2048 -i -D "/home/postgres/data"' &. Try starting postmaster with 'nice': nice /usr/bin/postmaster -B 2048 -i -D /home/postgres/data & -- Igor Ro

Re: [GENERAL] CPU killer

2000-10-27 Thread Alfred Perlstein
* Vilson farias <[EMAIL PROTECTED]> [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/postma

[GENERAL] CPU killer

2000-10-27 Thread Vilson farias
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