Re: question on parallelism

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: question on parallelism
Дата
Msg-id CAKt_ZftKq=WR9_VdWigG9MFpc+U8eXZxSSB5-JSmBmRA1Jk7OA@mail.gmail.com
обсуждение исходный текст
Ответ на question on parallelism  (Andrew McIntyre <amcintyre@m-m.com>)
Ответы Re: question on parallelism
Список pgsql-general



On Wed, Jan 1, 2014 at 7:35 PM, Andrew McIntyre <amcintyre@m-m.com> wrote:
does postgres have this capability? specifically local intrapartition?
http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.admin.partition.doc/doc/c0004557.html

Nope.  Here's a quick breakdown of what is done in parallel and what is done sequentially in PostgreSQL.

Separate queries run in parallel, and can piggy back on eachother's sequential scans.  In essence all of the work that is done in parallelism affects parallel queries.

There is no intra-query parallelism however.  This means that partitioning doesn't generally help here (although sequential scans on the same partition by different queries can run in parallel with good results, a single query cannot run several scans on different partitions in parallel).

If you need this sort of feature you are going to either need to go to a related product (like Postgres-XC) or you are going to need to have some other layer that can do the parallelism.

Best Wishes,
Chris Travers
 
sorry for all the newbie pg questions...



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

В списке pgsql-general по дате отправления:

Предыдущее
От: Andrew McIntyre
Дата:
Сообщение: question on parallelism
Следующее
От: "Janek Sendrowski"
Дата:
Сообщение: Re: How to delete completely duplicate rows