Postgres Pro
Downloads
Home   >   mailing lists

Re: Is clustering possible to enhance the performance? - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: Is clustering possible to enhance the performance?
Date
Msg-id 200312012237.hB1MbVF23686@candle.pha.pa.us
Whole thread Raw
In response to Is clustering possible to enhance the performance?  (LIANHE SHAO <lshao2@jhmi.edu>)
List pgsql-performance
Tree view 
LIANHE SHAO wrote:
> Hello,
> I am wondering if it is possible to use several
> machine as cluster to boost the slow queries. Is
> that possible? Anybody have tried that before?
>
> Initially, I was thinking to use dual CPUS instead
> of one. but it is not correct because pgsql is not
> multi-threaded.

Dual cpu's allow multiple backends to use different cpu's, but a single
session can't use more than one cpu.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: LIANHE SHAO
Date:
Subject: Is clustering possible to enhance the performance?
Next
From: Tom Lane
Date:
Subject: Re: A question on the query planner