Thread: What happens if tuple queue is full
Hi, Does anybody know what will happen if tuple queue is full, which is used by the parallel leader and workers? In my understanding memory used for the queue is a dynamic shared memory and it could be full. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
On Wed, Jul 6, 2016 at 10:57 AM, Tatsuo Ishii <ishii@postgresql.org> wrote: > Hi, > > Does anybody know what will happen if tuple queue is full, which is > used by the parallel leader and workers? In my understanding memory > used for the queue is a dynamic shared memory and it could be full. The queue can gets full in the case where the leader is processing is slow than the worker is producing tuples. In those scenarios, the worker waits until the the queue gets empty to place the new satisfied record.The worker gets awaken whenever the leader finishes reading the data from queue. Regards, Hari Babu Fujitsu Australia
Hari, > The queue can gets full in the case where the leader is processing is slow > than the worker is producing tuples. In those scenarios, the worker waits > until the the queue gets empty to place the new satisfied record.The worker > gets awaken whenever the leader finishes reading the data from queue. Thanks for the quick response! That is useful information. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp