Re: relcache reference leak on refresh materialized view concurrently

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: relcache reference leak on refresh materialized view concurrently
Дата
Msg-id 31494.1395086407@sss.pgh.pa.us
обсуждение исходный текст
Ответ на relcache reference leak on refresh materialized view concurrently  (yamamoto@valinux.co.jp (YAMAMOTO Takashi))
Ответы Re: relcache reference leak on refresh materialized view concurrently  (yamamoto@valinux.co.jp (YAMAMOTO Takashi))
Список pgsql-bugs
yamamoto@valinux.co.jp (YAMAMOTO Takashi) writes:
> the following patch fixes missing index_close in case
> the mv has non-unique indexes.

Hm ... I see the leak, I think, but isn't this an extraordinarily
complex patch?  Looks like adding

    else
    {
        index_close(indexRel, NoLock);
    }

at the bottom of the "if" would also fix the problem, and would be
far easier to verify.

            regards, tom lane

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

Предыдущее
От: Jeff Frost
Дата:
Сообщение: Re: BUG #9606: pg_class relhaspkey column not updated on removal of primary key
Следующее
От: Noah Misch
Дата:
Сообщение: Re: BUG #9472: pg_dumpall fails with "unrecognized node type: 650"