Re: BUG #19018: high memory usage and "stack depth limit exceeded", with GiST index on ltree

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: BUG #19018: high memory usage and "stack depth limit exceeded", with GiST index on ltree
Дата
Msg-id 736361755163356@mail-sendbernar-production-main-67.sas.yp-c.yandex.net
обсуждение исходный текст
Ответ на Re: BUG #19018: high memory usage and "stack depth limit exceeded", with GiST index on ltree  (Dilip Kumar <dilipbalaut@gmail.com>)
Ответы Re: BUG #19018: high memory usage and "stack depth limit exceeded", with GiST index on ltree
Список pgsql-bugs
Hello

This reminded me of some very old bug reports, like mine:
https://www.postgresql.org/message-id/15431-7a89470f7879bed4%40postgresql.org
Still reproduces giving different results depending on the order of operations. The proposed patch makes the behavior
thesame in both cases.
 

Since this code path may be reachable by the user, instead of elog there should be ereport with a more user-friendly
description.I would suggest something more like the text used for btree in a case like this. (ereport in
_bt_check_third_page)

    ereport(ERROR,
            (errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
             errmsg("index row size %zu exceeds gist maximum %zu for index \"%s\""...
                         errdetail("Index row references tuple (%u,%u) in relation \"%s\".",...
                         errhint("Values larger than 1/2 of a buffer page cannot be indexed"...

regards, Sergei



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