How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?
Дата
Msg-id CA+i5JwYMZ_eUtbdGBX9vg2GQzpTLo9m+bMoW1wniEqVv5sxV-w@mail.gmail.com
обсуждение исходный текст
Ответы Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?  (Steve Midgley <science@misuse.org>)
Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-sql
Дерево обсуждения
There is a plpgsql script that have a loop to carry out the same recursive queries.

The estimation of iteration is in the order of tens of thousands.

What is the best way of making using parallel query strategy.

Any examples?

Regards,

David

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Long running processes and commit writing to disk
Следующее
От: Steve Midgley
Дата:
Сообщение: Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?