Thread: Is clustering possible to enhance the performance?

Is clustering possible to enhance the performance?

From
LIANHE SHAO
Date:
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.

Any suggestions are welcome and appreciated,

Regards,
William


Re: Is clustering possible to enhance the performance?

From
Bruce Momjian
Date:
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