Parrallel query execution for UNION ALL Queries
От | Benjamin Arai |
---|---|
Тема | Parrallel query execution for UNION ALL Queries |
Дата | |
Msg-id | 39160.131.107.65.118.1184775275.squirrel@webmail.benjaminarai.com обсуждение исходный текст |
Ответы |
Re: [PERFORM] Parrallel query execution for UNION ALL Queries
Re: [PERFORM] Parrallel query execution for UNION ALL Queries |
Список | pgsql-general |
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 simultaiously or what? If not, is there a way to execute the query on both in parrallel then aggregate the results? To give some context, I have a very large amount of new data being loaded each week. Currently I am partitioning the data into a new table every month which is working great from a indexing standpoint. But I want to parrallelize searches if possible to reduce the perofrmance loss of having multiple tables. Benjamin
В списке pgsql-general по дате отправления: