Re: [COMMITTERS] pgsql: Fix an O(N^2) problem in foreign key references.

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: [COMMITTERS] pgsql: Fix an O(N^2) problem in foreign key references.
Дата
Msg-id 55F83ABF.2080609@wi3ck.info
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: Fix an O(N^2) problem in foreign key references.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [COMMITTERS] pgsql: Fix an O(N^2) problem in foreign key references.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 09/15/2015 10:58 AM, Tom Lane wrote:
> I wrote:
>> Jan Wieck <jan@wi3ck.info> writes:
>>> I'm able to reproduce that failure with CLOBBER_CACHE_ALWAYS and it
>>> definitely is caused by this commit. Do you want to back it out for the
>>> time being? Kevin is on vacation right now.
>
>> I'll take a look today, and either fix it if I can find the problem
>> quickly or back it out.
>
> The answer is "back it out", because this patch is fundamentally and
> irretrievably broken.  You can't just clobber the hashtable like that,
> because there are very possibly active uses of hashtable entries in
> outer function call levels.

Ok.

Would it be appropriate to use (Un)RegisterXactCallback() in case of 
detecting excessive sequential scanning of that cache and remove all 
invalid entries from it at that time?


Regards, Jan

-- 
Jan Wieck
Senior Software Engineer
http://slony.info



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

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: RLS open items are vague and unactionable
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Can extension build own SGML document?