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

2007-08-09 Thread llonergan
On Jul 18, 11:50 am, [EMAIL PROTECTED] ("Jim C. Nasby") wrote: > 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

[GENERAL] Parrallel query execution for UNION ALL Queries

2007-07-18 Thread Benjamin Arai
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 Postgresql execute WHERE blah="food" on both table sim