Re: percentile value check can be slow

2017-11-19 Thread jotpe
On 19.11.2017 18:49, David Fetter wrote: On Sun, Nov 19, 2017 at 01:23:42PM +0100, Tomas Vondra wrote: Hi, On 11/19/2017 03:10 AM, David Fetter wrote: On Sat, Nov 18, 2017 at 11:05:47PM +0100, Tomas Vondra wrote: Hi, ... Is 'recognizer' an established definition I should know? Is it the

percentile value check can be slow

2017-11-18 Thread jotpe
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