I think your first thought was good.
How high ? I think it's a matter of convention, certainly more than default
100.
czw., 21 lis 2019 o 02:05 Andy Fan napisał(a):
>
>
> On Thu, Oct 31, 2019 at 11:07 PM Tom Lane wrote:
>
>>
>>
>> Possibly this could be finessed by only trying to find duplica
hen
ResetExprContext is called ?
czw., 31 paź 2019 o 16:52 Andres Freund napisał(a):
> Hi,
>
> On October 31, 2019 8:51:11 AM PDT, Andrzej Barszcz
> wrote:
> >x <> 0 is evaluated first, 1/x only when x <> 0, not ?
> >
> >czw., 31 paź 2019 o 16:45 Tom Lan
Having ExprContext is it possible to know which ExprState is linked with it
?
Hi
Main goal of this patch is to avoid repeated calls of immutable/stable
functions.
This patch is against version 10.10.
I guess same logic could be implemented up till version 12.
--- src/include/nodes/execnodes.h 2019-08-05 23:16:54.0 +0200
+++ src/include/nodes/execnodes.h 2019-11-03 2
x <> 0 is evaluated first, 1/x only when x <> 0, not ?
czw., 31 paź 2019 o 16:45 Tom Lane napisał(a):
> Andres Freund writes:
> > Potentially related note: for nodes like seqscan, combining the qual and
> projection processing into one expression seems to be a noticable win (at
> least when tak
Hi
I almost finished patch optimizing non volatile function calls.
select f(t.n) from t where f(t.n) > 10 and f(t.n) < 100; needs 3 calls of
f() for each tuple,
after applying patch only 1.
Any pros and cons ?
Dear hackers,
I would be happy when checkRuleResultList in rewriteDefine.c lost so strict
conditions for returning clause. Are there any reasons to have such
restriction for views ?
What I mean in short:
create view ... as select MAIN_TABLE ... joins ...
1. Updating view means updating MAIN_TAB
