Re: [GENERAL] Hardware optimising

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Andy Lewis <alewis(at)roundnoon(dot)com>
Cc: "Aaron J(dot) Seigo" <aaron(at)gtv(dot)ca>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Hardware optimising
Date: 1999-08-27 01:14:10
Message-ID: 199908270114.VAA06380@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 1999-08-27 01:29:59 Re: [GENERAL] Hardware optimising
Previous Message Anand Surelia 1999-08-27 00:43:06 Pg.pm for Windows?