Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode
Дата
Msg-id CAA4eK1L2Gm7qhX6sGLv+6UUUt+UBE6U=pSoxD9KWXFv3nUHYJA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы RE: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
Список pgsql-committers
On Fri, Mar 26, 2021 at 11:07 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Wed, Mar 24, 2021 at 12:14 AM Andres Freund <andres@anarazel.de> wrote:
> >
> >
> > Shouldn't we have this in IndexOptInfo already?
> >
>
> No, because I think we don't build IndexOptInfo for target tables
> (tables in which insert is performed). It is only built for tables to
> scan. However, I think here we could cache parallel-safety info in the
> index rel descriptor and can use it for next time. This will avoid
> checking expressions each time.
>

On further investigation, it seems we can't rely on the cached
information of parallel-safety in rel descriptor because we don't
invalidate it if someone changes function property say from safe to
unsafe or vice-versa. We need to think of some other idea here, simply
caching rel descriptors won't work. I think we need to further discuss
this topic on -hackers.

-- 
With Regards,
Amit Kapila.



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: pgsql: Fix typos and grammar in documentation and code comments
Следующее
От: Magnus Hagander
Дата:
Сообщение: pgsql: Fix typo