From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Jojo Paderes <jojo.paderes@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Date: Thu, 23 Mar 2006 10:38:21 -0600
Message-ID: <1143131901.17999.67.camel@state.g2switchworks.com> (raw)
In-Reply-To: <65f9ddfb0603222219r1742c2aevda37acd55ca845be@mail.gmail.com>
References: <65f9ddfb0603222219r1742c2aevda37acd55ca845be@mail.gmail.com>
On Thu, 2006-03-23 at 00:19, Jojo Paderes wrote:
> I'd like to know if the latest PostgreSQL release can scale up by
> utilizing multiple cpu or dual core cpu to boost up the sql
> executions.
>
> I already do a research on the PostgreSQL mailing archives and only
> found old threads dating back 2000. A lot of things have improved with
> PostgreSQL and hopefully the support for multiple cpu or dual cores is
> already provided.
Can a single query be split up into parts and run on separate processors
at the same time? No.
Can multiple incoming queries be run on different processors for better
performance? Yes.
Has someone been working on the problem of splitting a query into pieces
and running it on multiple CPUs / multiple machines? Yes. Bizgress has
done that.
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: smarlowe@g2switchworks.com, jojo.paderes@gmail.com
Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
In-Reply-To: <1143131901.17999.67.camel@state.g2switchworks.com>
* 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