Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7BCDB9FBED8; Wed, 18 Jul 2007 15:50:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 48779-04; Wed, 18 Jul 2007 15:50:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 3C73A9FBEDE; Wed, 18 Jul 2007 15:50:12 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 30F5E564BE; Wed, 18 Jul 2007 13:50:11 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 18 Jul 2007 13:50:07 -0500 Date: Wed, 18 Jul 2007 13:50:07 -0500 From: "Jim C. Nasby" To: Scott Marlowe Cc: me@benjaminarai.com, pgsql-performance@postgresql.org, pgsql-general@postgresql.org Subject: Re: [PERFORM] Parrallel query execution for UNION ALL Queries Message-ID: <20070718185007.GC39272@nasby.net> References: <39160.131.107.65.118.1184775275.squirrel@webmail.benjaminarai.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="en6jyp4HM4Tn+Q16" Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070718:scott.marlowe@gmail.com::hoPrq8exJ4ioXTue:00000000000000 0000000000000000000000005MgN X-Hashcash: 1:20:070718:me@benjaminarai.com::cWhND1UGgJLhfUNU:000000000000000000 0000000000000000000000000EqD X-Hashcash: 1:20:070718:pgsql-performance@postgresql.org::M9SPVwvfvW1pRhIj:00000 0000000000000000000000001Pi0 X-Hashcash: 1:20:070718:pgsql-general@postgresql.org::1KBwppxW569GfVbu:000000000 0000000000000000000000001SA/ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/748 X-Sequence-Number: 117349 --en6jyp4HM4Tn+Q16 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jul 18, 2007 at 11:30:48AM -0500, Scott Marlowe wrote: > EnterpriseDB, a commercially enhanced version of PostgreSQL can do > query parallelization, but it comes at a cost, and that cost is making > sure you have enough spindles / I/O bandwidth that you won't be > actually slowing your system down. I think you're thinking ExtendDB. :) --=20 Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --en6jyp4HM4Tn+Q16 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFGnmDfdO30qud8SkgRAjuZAKCPx30vpsQrVB7+KR5K5fwgIqi2RACgoHxv pHnuKqWDTu2uJM8Fw5bvKlo= =FTnn -----END PGP SIGNATURE----- --en6jyp4HM4Tn+Q16--