Re: BUG #18831: Particular queries using gin-indexes are not interruptible, resulting is resource usage concerns.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #18831: Particular queries using gin-indexes are not interruptible, resulting is resource usage concerns.
Дата
Msg-id 1126691.1744435987@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #18831: Particular queries using gin-indexes are not interruptible, resulting is resource usage concerns.  (Vinod Sridharan <vsridh90@gmail.com>)
Ответы Re: BUG #18831: Particular queries using gin-indexes are not interruptible, resulting is resource usage concerns.
Список pgsql-bugs
Vinod Sridharan <vsridh90@gmail.com> writes:
> Since this is also called in the regular consistent function, this
> would be adding work in the regular consistent path - where the caller
> happens to reset the array for every invocation currently.

Ah, so you're just worried about the extra work in that path?
But MAX_MAYBE_ENTRIES is only 4, so I can't believe it'd amount
to much.

I am wondering about a test case.  I'm not thrilled about building
a specialized opclass just to test this.  contrib/hstore and
contrib/intarray already have opclasses with no triconsistent
function, so they should (and do) exercise shimTriConsistentFn
already.  But their tests failed to expose this bug.  I spent
a bit of time trying to add an example that would show the bug
in one or the other of those, and failed so far.  Any ideas?

            regards, tom lane



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