Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1F9FD9FB3C0; Thu, 19 Jul 2007 07:14:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32014-10; Thu, 19 Jul 2007 07:14:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id EC7C49FB3D6; Thu, 19 Jul 2007 07:14:34 -0300 (ADT) Received: from dim (LAubervilliers-151-11-28-79.w193-251.abo.wanadoo.fr [193.251.57.79]) by hi-media.com (Postfix) with ESMTP id C99C71880D5; Thu, 19 Jul 2007 12:12:58 +0200 (CEST) From: Dimitri Fontaine Organization: Hi-Media To: pgsql-general@postgresql.org Subject: Re: [PERFORM] Parrallel query execution for UNION ALL Queries Date: Thu, 19 Jul 2007 12:14:29 +0200 User-Agent: KMail/1.9.7 Cc: "Jonah H. Harris" , me@benjaminarai.com, pgsql-performance@postgresql.org References: <39160.131.107.65.118.1184775275.squirrel@webmail.benjaminarai.com> <36e682920707180921l149759e6jbb73e0c3f0460499@mail.gmail.com> In-Reply-To: <36e682920707180921l149759e6jbb73e0c3f0460499@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1544756.WtRvtpIL6t"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200707191214.32047.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.048 tagged_above=0 required=5 tests=AWL=-0.053, BAYES_50=0.001, RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200707/797 X-Sequence-Number: 117398 --nextPart1544756.WtRvtpIL6t Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, Le mercredi 18 juillet 2007, Jonah H. Harris a =E9crit=A0: > On 7/18/07, Benjamin Arai wrote: > > But I want to parrallelize searches if possible to reduce > > the perofrmance loss of having multiple tables. > > PostgreSQL does not support parallel query. Parallel query on top of > PostgreSQL is provided by ExtenDB and PGPool-II. Seems to me that :=20 - GreenPlum provides some commercial parallel query engine on top of PostgreSQL, =20 - plproxy could be a solution to the given problem. https://developer.skype.com/SkypeGarage/DbProjects/PlProxy Hope this helps, =2D-=20 dim --nextPart1544756.WtRvtpIL6t Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBGnzmIlBXRlnbh1bkRAolNAJwMC4fnfrsmEK0Nnd0bwMvqiqIN2wCfaovI 3CVdToOG+uZKPf7A9y76QmE= =5vl0 -----END PGP SIGNATURE----- --nextPart1544756.WtRvtpIL6t--