Обсуждение: cpu usage on the linux machine

If the linux box has 8 CPU's, is there a way to configure for Postgres to user 6 of them? how? Thanks!

---

Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jessica Richard wrote:
> If the linux box has 8 CPU's, is there a way to configure for Postgres to user 6 of them? how? Thanks!

No.

Joshua D. Drake

>
>
> ---------------------------------
> Fussy? Opinionated? Impossible to please? Perfect.  Join Yahoo!'s user panel and lay it on us.


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGun6eATb/zqfZUUQRAg3wAJ9iiDQY809thJ8S71U8ev17OlwleQCeJJGU
qZ7l7Lj9b3dnww9fml9uYoU=
=8y+7
-----END PGP SIGNATURE-----

On 8/8/07, Jessica Richard <rjessil@yahoo.com> wrote:
> If the linux box has 8 CPU's, is there a way to configure for Postgres to
> user 6 of them? how? Thanks!

There are some kernel hacks for CPU affinity.  they might be able to
do a bit of that.

Other than that, limited postgresql to only 6 non-superuser
connections might do the trick.

Jessica Richard wrote:
> If the linux box has 8 CPU's, is there a way to configure for Postgres
> to user 6 of them? how? Thanks!
Try that:
http://www.bullopensource.org/cpuset/

--
Andrzej Zawadzki
PLD
<jid:zawadaa@pld-linux.org>