Re: Greatest Common Divisor

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Greatest Common Divisor
Дата
Msg-id 6387.1578157308@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Greatest Common Divisor  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> OTOH, for numeric inputs, this could easily end up needing many
> thousands of divisions and it's not hard to construct inputs that take
> minutes to compute, although this is admittedly with ridiculously
> large inputs (~10^130000), and AFAICS, the performance is OK with
> "normal" sized inputs. Should we put a limit on the size of the
> inputs?

No, but a CHECK_FOR_INTERRUPTS in the loop would be well-advised,
if there's not one already inside the called functions.

> There are apparently more efficient algorithms, but I think that
> should definitely be kept out of scope for this patch.

+1

            regards, tom lane



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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: allow disabling indexscans without disabling bitmapscans
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Errors when update a view with conditional-INSTEAD rules