percentile value check can be slow

Поиск
Список
Период
Сортировка
От jotpe
Тема percentile value check can be slow
Дата
Msg-id 3f60fe5f-6df0-d889-ebad-def2dcb4db57@posteo.de
обсуждение исходный текст
Ответы Re: percentile value check can be slow
Список pgsql-hackers
I tried to enter invalid percentile fractions, and was astonished that 
it seems to be checked after many work is done?

psql (11devel)
Type "help" for help.

jotpe=# \timing
Timing is on.
jotpe=# select percentile_cont(array[0,0.25,0.5,1,1,null,2]) within 
group(order by txk) from klima_tag;
ERROR:  percentile value 2 is not between 0 and 1
Time: 19155,565 ms (00:19,156)
jotpe=# select count(*) from klima_tag;  count
---------- 13950214
(1 row)

Time: 933,847 ms


Best regards Johannes


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

Предыдущее
От: 高增琦
Дата:
Сообщение: Re: no library dependency in Makefile?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [JDBC] [HACKERS] Channel binding support for SCRAM-SHA-256