From: Shaun Thomas <sthomas@peak6.com>
To: Maciek Sakrejda <msakrejda@truviso.com>
Cc: Didik Prasetyo <prasetyodidik62@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: partition query on multiple cores
Date: Tue, 10 May 2011 11:22:26 -0500
Message-ID: <4DC96642.2090900@peak6.com> (raw)
In-Reply-To: <BANLkTi=8VQyVAH+yP=qcbET-93rSiGRk=Q@mail.gmail.com>
References: <248032.47204.qm@web77301.mail.sg1.yahoo.com>
<BANLkTi=8VQyVAH+yP=qcbET-93rSiGRk=Q@mail.gmail.com>
On 05/10/2011 10:06 AM, Maciek Sakrejda wrote:
>> I have 8-core server, I wanted to ask whether a query can be divided for
>> multiple processors or cores, if it could be what to do in postgresql
>
> No, at this time (and for the foreseeable future), a single query will
> run on a single core.
It can *kinda* be done. Take a look at GridSQL. It's really good for
splitting up reporting-like queries that benefit from parallel access of
large tables. It's not exactly Hadoop, but I ran a test on a single
system with two separate instances of PostgreSQL, and a single query
over those two nodes cut execution time in half.
It's meant for server parallelism, so I wouldn't necessarily recommend
splitting your data up across nodes on the same server. But it seems to
deliver as promised when used in the right circumstances.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@peak6.com
______________________________________________
See http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email
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: sthomas@peak6.com, msakrejda@truviso.com, prasetyodidik62@yahoo.com
Subject: Re: partition query on multiple cores
In-Reply-To: <4DC96642.2090900@peak6.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