| From: | "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> |
|---|---|
| To: | <pgsql-general(at)hub(dot)org> |
| Cc: | "SIMONE Carla MOSENA" <simone(dot)mosena(at)digitro(dot)com(dot)br> |
| Subject: | CPU killer |
| Date: | 2000-10-27 21:12:57 |
| Message-ID: | 002401c0405a$ae595be0$98a0a8c0@dti.digitro.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Regards from Brazil,
José Vilson de Mello de Farias
Dígitro Tecnologia Ltda.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2000-10-27 21:26:09 | Re: Re: Issues about postgresql file names |
| Previous Message | Ben Souther | 2000-10-27 21:12:09 | RE: Foreign key |