Re: relcache reference leak on refresh materialized view concurrently - Mailing list pgsql-bugs

From yamamoto@valinux.co.jp (YAMAMOTO Takashi)
Subject Re: relcache reference leak on refresh materialized view concurrently
Date
Msg-id 20140318013042.BB80F71F23@kuma.localdomain
Whole thread Raw
In response to Re: relcache reference leak on refresh materialized view concurrently  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

i tend to think it's simpler, but it's a matter of taste.

>
>     else
>     {
>         index_close(indexRel, NoLock);
>     }
>
> at the bottom of the "if" would also fix the problem, and would be
> far easier to verify.

yes, it's probably the physically smallest patch.

YAMAMOTO Takashi

>
>             regards, tom lane

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #9118: WAL Sender does not disconnect replication clients during shutdown
Next
From: kukinek1@gmail.com
Date:
Subject: BUG #9619: error creating plperl , plperlu language , plperl.dll error