Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8BA141337B80 for ; Tue, 10 May 2011 15:58:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 86066-01-3 for ; Tue, 10 May 2011 18:58:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gransy.com (mail.gransy.com [82.208.29.194]) by mail.postgresql.org (Postfix) with ESMTP id 87B8E1337C1B for ; Tue, 10 May 2011 15:57:49 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.gransy.com (Postfix) with ESMTP id 777F34A220B for ; Tue, 10 May 2011 20:57:48 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at nathalia.gransy.com Received: from mail.gransy.com ([127.0.0.1]) by localhost (Nathalka.gransy.com.gransy.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id gL44gm6-vSki for ; Tue, 10 May 2011 20:57:48 +0200 (CEST) Received: from [192.168.1.221] (ip-94-112-0-189.net.upcbroadband.cz [94.112.0.189]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.gransy.com (Postfix) with ESMTPSA id ECAD64A21D3 for ; Tue, 10 May 2011 20:57:47 +0200 (CEST) Message-ID: <4DC98AAB.10005@fuzzy.cz> Date: Tue, 10 May 2011 20:57:47 +0200 From: Tomas Vondra User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101219 Lightning/1.0b3pre Thunderbird/3.1.7 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: partition query on multiple cores References: <248032.47204.qm@web77301.mail.sg1.yahoo.com> <4DC96642.2090900@peak6.com> In-Reply-To: <4DC96642.2090900@peak6.com> X-Enigmail-Version: 1.1.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/133 X-Sequence-Number: 43642 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