pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: partition query on multiple cores
Date: Tue, 10 May 2011 20:57:47 +0200
Message-ID: <4DC98AAB.10005@fuzzy.cz> (raw)
In-Reply-To: <4DC96642.2090900@peak6.com>
References: <248032.47204.qm@web77301.mail.sg1.yahoo.com>
	<BANLkTi=8VQyVAH+yP=qcbET-93rSiGRk=Q@mail.gmail.com>
	<4DC96642.2090900@peak6.com>

Dne 10.5.2011 18:22, Shaun Thomas napsal(a):
> 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.

Or pgpool-II, that can give you something similar.

http://pgpool.projects.postgresql.org/

regards
Tomas



view thread (6+ messages)  latest in thread

Message-ID: <4DC98AAB.10005@fuzzy.cz>
Permalink:  ../4DC98AAB.10005@fuzzy.cz/
Also on:    postgresql.org/message-id/4DC98AAB.10005@fuzzy.cz

 · 

reply

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: tv@fuzzy.cz
  Subject: Re: partition query on multiple cores
  In-Reply-To: <4DC98AAB.10005@fuzzy.cz>

* 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