Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 195051337BC8 for ; Tue, 10 May 2011 01:32:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 19470-04 for ; Tue, 10 May 2011 04:32:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nm4.bullet.mail.sg1.yahoo.com (nm4.bullet.mail.sg1.yahoo.com [115.178.12.226]) by mail.postgresql.org (Postfix) with SMTP id 1F9AE1337B4E for ; Tue, 10 May 2011 01:32:08 -0300 (ADT) Received: from [115.178.12.220] by nm4.bullet.mail.sg1.yahoo.com with NNFMP; 10 May 2011 04:32:05 -0000 Received: from [115.178.12.218] by tm1.bullet.mail.sg1.yahoo.com with NNFMP; 10 May 2011 04:32:05 -0000 Received: from [127.0.0.1] by omp1003.mail.sg1.yahoo.com with NNFMP; 10 May 2011 04:32:05 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 349249.32005.bm@omp1003.mail.sg1.yahoo.com Received: (qmail 50020 invoked by uid 60001); 10 May 2011 04:32:05 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1305001925; bh=ISS0ZXqMDGPbvNyMoX/gU5341RGGuY2qABL2+17rnYo=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=jhnHnjveVbB6d1kx318YFi4u2mDN2xpgYI0A8oYrnFyzlpJ8Ui/6l9cGGZI/qkVHdKcnJY/jVu2g72bKdm0GfnrxfcdAiUINKqZeEaEpIKhSAdUNtV69aB680BNUaj6D46+3xihhIoT2SSHzSOglMV0bhnRZWjzNKliwWGXT4k8= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=xjctpmGs7t7oRhOHmgeeMjHItAPGz2gQvb+I3KjuBw+erQO1HvJE7EAlkm1ii8xp28qxfGygGGY5vAADIKI9Z6l9XXNXQ2XpK232a4SCx8ONANzvXgRarTRTUN9brUDvs4Z5p5G1eo9xK3Uv3AUR9EVzltXgi4iyFQAE2XpVZxc=; Message-ID: <248032.47204.qm@web77301.mail.sg1.yahoo.com> X-YMail-OSG: VPHmuJgVM1m_EU944uck1Hr6XxYc0zgsarAPlpiInZto_20 2rdGt2OBMpUrzVH0f8obKQfVCA_h2w.ga9XwIMlz70NN6UlOOz3wvhk1N9hN FtOLO0R5b.lbLXBUnFv.Hj4SdctGTAR797vr5sPancPJGdFBc44.5BbX2XD7 usxYwm4TKXNSvRTpBaUCnH2gZGwhZ25PN3YS3kFp4LRUOWVJwt3eF0VjTdZq NfMoM5_k7HqITPVH4ZF29.CTGFxG9L_HJITb3aMkzCXD62G2oGnwSIwxuLpO 0qtkjcIuxFoe9u_Hmy_OmX75cSrs- Received: from [114.79.51.120] by web77301.mail.sg1.yahoo.com via HTTP; Tue, 10 May 2011 12:32:05 SGT X-Mailer: YahooMailRC/559 YahooMailWebService/0.8.110.299900 Date: Tue, 10 May 2011 12:32:05 +0800 (SGT) From: Didik Prasetyo Subject: partition query on multiple cores To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-852281821-1305001925=:47204" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.344 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/115 X-Sequence-Number: 43624 --0-852281821-1305001925=:47204 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I have 8-core server, I wanted to ask whether a query can be divided for = =0Amultiple processors or cores, if it could be what to do in postgresql=0A= =0AThanks=0A --0-852281821-1305001925=:47204 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
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
Thanks
=0A
--0-852281821-1305001925=:47204--