On Sun, Apr 17, 2022 at 8:53 AM Kumar, Mukesh <mku...@peabodyenergy.com> wrote:
> We request you to please provide some assistance on below issue and it is > impacting the migration project. > I suggest you try and re-write the loop-based function into a set-oriented view. Specifically, I think doing: "array_agg(DISTINCT paymenttype)" and then checking for various array results will be considerably more efficient. Or do a combination: write the set-oriented query in an SQL function. You should not need pl/pgsql for this and avoiding it should improve performance. David J. p.s., The convention on these lists is to inline post and remove unneeded context. Or at least bottom post.
