Re: [GENERAL] Hardware optimising - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] Hardware optimising
Date
Msg-id 199908270114.VAA06380@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] Hardware optimising  (Andy Lewis <alewis@roundnoon.com>)
List pgsql-general
> What scheduler are we speaking of here?
>
> Andy
>
> On Thu, 26 Aug 1999, Bruce Momjian wrote:
>
> > > as for the processor, this will see an increase, of course. note,
> > > however, that since PostgreSQL is _not_ multithreaded, that it will run
> > > only on one of the processors. (i'm about to assume you are using linux
> > > here... 'scuse me if i'm wrong) however, the good news is that you can
> > > encourage linux (through the scheduler) to run postgres on one of the
> > > processors and everything else on the other one. this should give the
> > > database its own processor more oft than not. things may still drift,
> > > etc... but it will be better this way....
> >
> > Different backends can use different CPU's, no problem.

Each backend is a different process, so they can run at the same time on
multiple cpu's.  Any OS that can handle multiple cpu's can handle
PostgreSQL running multiple backends at the same time.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Anand Surelia
Date:
Subject: Pg.pm for Windows?
Next
From: Mike Mascari
Date:
Subject: Re: [GENERAL] Hardware optimising