Re: Parallel sec scan in plpgsql

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Parallel sec scan in plpgsql
Дата
Msg-id CAA4eK1JTaqOBVQW+jxUR+66OoAR=v84=YwsT2QGhU3+WyfL6nw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel sec scan in plpgsql  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Thu, Sep 22, 2016 at 7:32 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Thu, Sep 22, 2016 at 8:36 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>> I think for certain cases like into clause, the rows passed will be
>> equal to actual number of rows, otherwise it will generate error.  So
>> we can pass that information in executor layer.  Another kind of cases
>> which are worth considering are when from plpgsql we fetch limited
>> rows at-a-time, but we fetch till end like the case of
>> exec_stmt_return_query().
>
> Yes, I think that those cases can be considered.  Some careful code
> inspection will be needed to make sure the cases we want to enable are
> safe, and some testing will be needed to make sure they behave
> properly.  But it doesn't sound like an unsolvable problem.  I hope
> someone who isn't me will decide to work on it.  :-)
>

makes sense.  I think along with that we can also evaluate, if we can
enable parallel query from other pl languages. I think if we can
enable parallelism from all pl languages in 10.0, that will be a good
step forward.

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Speed up Clog Access by increasing CLOG buffers
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pageinspect: Hash index support