Postgres Pro
Downloads
Home   >   mailing lists

Re: cpu usage on the linux machine - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: cpu usage on the linux machine
Date
Msg-id dcc563d10708081949j2383e028p35ace2633492cdfe@mail.gmail.com
Whole thread Raw
In response to cpu usage on the linux machine  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: "Michael Goldner"
Date:
Subject: Joining tables in two different databases?
Next
From: "Nick Fankhauser"
Date:
Subject: Re: Specific questions about wraparound and vacuum