From: Bruce Momjian <pgman@candle.pha.pa.us>
To: LIANHE SHAO <lshao2@jhmi.edu>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Is clustering possible to enhance the performance?
Date: Mon, 1 Dec 2003 17:37:31 -0500 (EST)
Message-ID: <200312012237.hB1MbVF23686@candle.pha.pa.us> (raw)
In-Reply-To: <6b5ba36baf6d.6baf6d6b5ba3@jhmimail.jhmi.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgman@candle.pha.pa.us, lshao2@jhmi.edu
Subject: Re: Is clustering possible to enhance the performance?
In-Reply-To: <200312012237.hB1MbVF23686@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox