Hi all.
I'm experiencing a strange behaviour with 8.1.8 (cannot do upgrades to 8.2 at
the moment).
On a 13+ million rows table I can do a query with results back in less than
100 ms. Result is a set of bigint.
But when I encapsulate that query into an "SQL" function with three parameters
the results come back in about one minute. The function contains just the same
query as above.
Of course there's been no change in indices or even into the table itself
between the two tests.
I'm almost sure I'm missing something, but have no clue about what!
Any hint?