Hi
I have a RULE that executes 5 queries. Each query executed is created a
plan to the view, that means that in the end I will have 5 query plans
to that view, when I only needed 1.
I don't know if this is the best way, but I'm doing 5 queries because I
have to pass to a function 17 parameters and postgres have the
limitation of 16. I have two tables of parameters, that I use. First I
delete all that could be there before, then I insert the new parameters
and after I execute my function, all inside the rule.
Can I do this in other way to improve the perfomance ?
Thanks, Luis Sousa