Re: [PERFORM] Parrallel query execution for UNION ALL Queries

2007-07-18 Thread Jim C. Nasby
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 syst

Re: [PERFORM] Parrallel query execution for UNION ALL Queries

2007-07-18 Thread Scott Marlowe
On 7/18/07, Benjamin Arai <[EMAIL PROTECTED]> wrote: Hi, If I have a query such as: SELECT * FROM (SELECT * FROM A) UNION ALL (SELECT * FROM B) WHERE blah='food'; Assuming the table A and B both have the same attributes and the data between the table is not partitioned in any special way, does

Re: [PERFORM] Parrallel query execution for UNION ALL Queries

2007-07-18 Thread Jonah H. Harris
On 7/18/07, Benjamin Arai <[EMAIL PROTECTED]> 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. -- Jonah H. Harr