Postgres Pro
Downloads
Home   >   mailing lists

Re: Dual processors for Postgres? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Dual processors for Postgres?
Date
Msg-id 200102122205.RAA27741@candle.pha.pa.us
Whole thread Raw
In response to Dual processors for Postgres?  ("G. Anthony Reina" <reina@nsi.edu>)
List pgsql-admin
Tree view 
> I may have a chance to upgrade the hardware for our db server in a few
> months time. Are there any advantages to using a dual processor system
> for Postgres?

If you are CPU bound, PostgreSQL can spread backends across CPU's.  If
you hare I/O bound, it will not help much.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@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-admin by date:

Previous
From: "G. Anthony Reina"
Date:
Subject: Dual processors for Postgres?
Next
From: Peter Eisentraut
Date:
Subject: Re: gmake