Hi, we've faced the situation when the operation WHERE UPPER(columnName) IN ('PRED1', 'PRED2', 'PRED3') works very bad. If I remove UPPER then it performs good. I've tried to play with projections and could not get it working properly. How can I solve that issue (maybe the problem is not in projecti...

Could anyone explain what is going on... I have following table: CREATE TABLE public.test ( a int, UpdateDate timestamp NOT NULL DEFAULT ('now()')::timestamptz ); INSERT INTO public.test (a) values (1); SELECT *, NOW() FROM public.test; And the output is: a UpdateDate NOW 1 2016-09-23 05:14:14 2016-...