Re: parallel-processing multiple similar query tasks - any example?

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема Re: parallel-processing multiple similar query tasks - any example?
Дата
Msg-id CA+i5JwaRZZZPkpaOtvVOCjLzjwhL0pMrpXGKa8M7Qrr7zS5Mbg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: parallel-processing multiple similar query tasks - any example?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: parallel-processing multiple similar query tasks - any example?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-general
Дерево обсуждения
Expand and explain please.
Regards,
David

On Thursday, 28 April 2022, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
On 2022-Apr-28, Shaozhong SHI wrote:

> Why sleep(1)?

It is sleeping to show that they are running concurrently.  If it runs
five sleeps of one second each and the whole command lasts one second,
then all sleeps ran in parallel.  Had the whole command taken five
seconds, you would know that the queries ran serially.

> It should be all active - doing work concurrently.

They are all active simultaneously.  You just need to supply your own
query, without any sleeps.

--
Álvaro Herrera

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: cursor variable must be a simple variable (LINE XX: OPEN vQuery.cursorReturn FOR )
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: parallel-processing multiple similar query tasks - any example?